what is the diff b/w target load plan and cbl?
Answer Posted / brahmareddy
cbl specifies the load order in to the number of targets based on primarykey and foreign key.this is vary useful when you r loading data in to snowflake dimentions.
target load order species the order in which data extract from sq tr
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What does update strategy mean, and what are the different option of it?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to Create a folder using pmrep command?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is different between the data warehouse and data mart?
How do you change a non-reusable transformation to reusable transformation?
what is SDLC way of code development?
Is it possible to create multiple domains on a single Informatica server?
How to extract sap data using informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to convert multiple rows to single row (multiple columns) in informatica
Enlist few areas or real-time situations where informatica is required.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain pmcmd command usage in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?