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
- 6948 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
Differences between version 7.x and 8.x.
How to differentiate between the active and passive transformations?
What is a sorter transformation?
Write the unconnected lookup syntax?
How is union transformation utilized?
What you know about transaction control transformation?
How can you define user defied event?
design of staging area?
What is status code in informatica?
What is the way to execute pl/sql script using informatica mapping?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Explain sessions and how many types of sessions are there?
What are the new features of Power Center 5.0?
What is domain in terms of informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
