transformation used by DMT job loads and acts upon each sheet (mostly) separately, so you can fill only parts you need and not worry about anything else; actually, if you removed unnecessary sheets, job would probably fail. As to first three rows, transformation is set up to ignore first two rows (if you are interested and have access to Spoon, have a look at Transactional_Asset transformation -- in top left corner, you'll find action called AST_LoadAssetPeople which loads data from sheet AST_LoadAssetPeople, which is the one you are interested in, and does so starting from row 2, which means third row because numbering starts from zero) so you won't have to delete them either.
Thanks for your reply, I got clear from your answer.
Can you please help me to understand about workbook, means let suppose wants to load CI support group relationship only so do I need to put data into AST_LoadAssetPeople sheet of transactional Asset workbook as I attached and other tabs like "AST_LoadBMC_BaseRelationship" , AST_LoadWorklog" and "Instruction remains same in workbook during load.
Please confirm me on this as well.
That's right, simply:
- download template (Transactional_Asset.xlsm)
- fill it with data you wish to load (eg. AST_LoadAssetPeople), while ignoring the rest
- save that worksheet under any name you want
- select "Using BMC Templates" when creating DMT job based on Asset BMC Template and remember to add worksheet from step 3 to load step
- run DMT job
Thanks a lot for your help.