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
- 7048 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
Write the unconnected lookup syntax?
Which is the t/r that builts only single cache memory?
What is meant by pre and post session shell command?
How many input parameters can exist in an unconnected lookup?
What is the use of source qualifier?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is union transformation?
how we can load rejected record's at run time?(not through bad files)
Plz can any one say me how to get the informatica certification materials and dumps
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are Dimensional table?
is it possible to index the data in cache of lkp transformation ?
