What is constraint based loading exatly? And how to do this?
I think it is when we have primary key-foreign key relation
ship. Is it correct?
please answer me.
Advance Thanks.
Answer Posted / om
Constraint Based Load order defines load the data into
multiple targets depend on the primay key foriegn key reltion.
set the option is: Double click the session
Configue Object check the Constraint Based Loading
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
In development project what is the process to follow for an etl developer from day1
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is mapplet in informatica?
what is song in infrmatica...?
Briefly define reusable transformation?
Explain the difference between a data warehouse and a data mart?
What is the session task and command task?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the Rank index port in Rank transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How identifying bottlenecks in various components of informatica and resolving them?
Did u used latest transformations of 8.6.0? for what?
What is rank transformation?