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
What are the types of schemas we have in data warehouse and what are the difference between them?
Differentiate between source qualifier and filter transformation?
Can you use flat files in Mapplets.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are active and passive transformations?
Why union transformation is an active transformation?
How to generate sequence numbers without using the sequence generator transformation?
How to do unit testing in informatica? How to load data in informatica ?
Write the different tools in the workflow manager?
How to partition the Session?
Explain lookup transformation in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Write the advantages of partitioning a session?
What is informatica metadata and where is it stored?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?