Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w target load plan and cbl?
- 3 Answers
- 27518 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
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is intricate mapping?
What is union transformation?
What is the Rank index port in Rank transformation?
What is the function of aggregator transformation?
What is the benefit of partitioning a session?
What is rank transform?
What could be the possible resons of locks by user?
what is the size of your data warehousing?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
tell me 5 session failure in real time how can you solve that in your project?
What do think which one is the better joiner or look up?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What's the layout of parameter file (what does a parameter file contain?)?
Can we get 1st record through Informatica(without sequence number).
