Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w target load plan and cbl?
- 3 Answers
- 27638 Views
- CTS, iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Target increases every day even though no new record was inserted
Quickly characterize reusable change?
How does the aggregator transformation handle null values?
How do you convert single row from source into three rows into target?
How can you generate reports in informatica?
How many input parameters can exist in an unconnected lookup?
What is meant by incremental aggregation?
What are the different options available for update strategy?
Explain the types of transformations?
How can we use mapping variables in informatica? Where do we use them?
what is the difference between informatica6.1 and infomatica7.1
