Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6991 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
explain abt ur project architecture?
How to delete duplicate row using informatica?
How to create Target definition for flat files?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How do you use reject loader.
How do you promote a non-reusable transformation to reusable transformation?
What are the modules in Power Center
Mention few power centre client applications with their basic purpose?
Please let me know how to make Data masking in informatica..
Differentiate between a database and data warehouse?
What if the source is a flat-file?
Briefly define reusable transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
write a query to retrieve the latest records from the table sorted by version(scd)
Describe expression transformation?
