Is it necessary to maintain the primary-foreign key relation
ship between the targets in informatica while loading using
constarint based loading or it is required only at database
level ??
- 1 Answers
- 6593 Views
- IBM, I also Faced
- E-Mail Answers
Answer / john
If they have already defined at databse level,then what is
the necessity of maintain the primary-foreign key
relationship at Informatica level.You just import those
tables from the database and load the data by developing
the mapping.but enable the option "constraint based load
ordering"in session config objects before you are going to
run the session. why because
informatica server(Integration Service) doesn't know the
relatioship between the target tables which you are going
to load eventhough they have already defined at databse
level.So you should use the option "Constarint Based load
ordering".
Then only Informatica server will check relationship
between the those tables and first it will load data in the
parent table(which has Primary key) and then child table
(which has foreign key)
| Is This Answer Correct ? | 2 Yes | 0 No |
What is a connected transformation?
From where we can start or use pmcmd?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
what r the transformations that r not involved in mapplet?
How does a rank transform differ from aggregator transform functions max and min?
How to load a Dimension ? and how to load a fact table?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
Explian the Process of deployment groups in informatica
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
Tell me about informatica architecture.
How to jion 2 tables, without using any condition?
Teradata 
