Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w target load plan and cbl?
- 3 Answers
- 27343 Views
- CTS, iGate, I also Faced
- E-Mail Answers
Answer Posted / vijay
Target load plan is that you can set at the Informatica
level whereas the Constraint based load ordering is what
happens at the database side.
Whenever you have multiple pipelines in your mapping, you
can set the order of execution of those pipelines, which to
run first and which next. Whenever u select the target load
plan, it displays the list of source qualifiers lying in
the different pipelines. You just need to arrange the
source qualifier as per your requirement and save your
mapping.
Constraint based load ordering is an option in the session
properties where the informatica understands that the
parent table has to be loaded before the child table. You
need not determine which table to load first and which
next, all you need to do is just check the 'Constraint
based load ordering' option in the session properties. This
applies when you have multiple targets in the same pipeline
simultaneously(like multiple targets from the same
transformation or multiple targets from the same output
group of a router etc..)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How we can use union transformation?
What if the source is a flat-file?
How does a sorter cache works?
Explain Dataware house architecture .how data flow from intial to end?
What is workflow? What are the components of the workflow manager?
How we can create indexes after completing the loan process?
What is sorter transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is a joiner transformation and why it is an active one?
How big was your fact table
Explain the difference between mapping parameter and mapping variable?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are pre and post-session shell commands?
How many ways a relational source definition can be updated and what are they?
