Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w target load plan and cbl?
- 3 Answers
- 27529 Views
- CTS, iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sai krishna karri
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 ? | 40 Yes | 0 No |
Answer / 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 |
Answer / 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 |
How u use pdf file in informatica source?
What are active and passive transformations?
Is it possible to have "5 source & 5 Target" in single mapping?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
what are the differences between powercenter 8.1 and powercenter 8.5?
which transformation uses cache?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
Why we require dwh in particular projects?
How the dimensions will be loaded?
Explain in detail about scd type 1 through mapping.
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
difference between repository database and repository service?
Teradata 
