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


Please Help Members By Posting Answers For Below Questions

What does update strategy mean, and what are the different option of it?

584


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?

652


How to Create a folder using pmrep command?

618


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

1695


What is different between the data warehouse and data mart?

626






How do you change a non-reusable transformation to reusable transformation?

592


what is SDLC way of code development?

1555


Is it possible to create multiple domains on a single Informatica server?

747


How to extract sap data using informatica?

604


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?

772


How to convert multiple rows to single row (multiple columns) in informatica

889


Enlist few areas or real-time situations where informatica is required.

588


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?

548


Explain pmcmd command usage in informatica

699


Name at least 5 different types of transformations used in mapping design and state the use of each.?

666