Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w target load plan and cbl?
- 3 Answers
- 27645 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
To import the flat file definition into the designer where should the flat file be placed?
What are the different types of repositories created using informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Under which circumstances, informatica server creates reject files?
Reusable transformation and shortcut differences
Explain what are the different versions of informatica?
What is the benefit of session partitioning?
What does “tail –f” command do and what is its use as an Informatica admin.
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can we use mapping variables in informatica? Where do we use them?
How you can differentiate between connected lookup and unconnected lookup?
How we can use union transformation?
What is the different lookup cache(s)?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Tell me about MD5 functions in informatica
