1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 ??

Question Posted / palthepu_santosh


Is it necessary to maintain the primary-foreign key relation ship between the targets in informatic..

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

Post New Answer

More Informatica Interview Questions

What are the advantages of informatica?

0 Answers  

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  




In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,

what is flat file override?

1 Answers   Cap Gemini, HP,

Define Incremental Aggregation?

2 Answers  

What is the difference between Normal load and Bulk load?

5 Answers  

What do you understand by SOA of Informatica?

0 Answers  

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

For more Informatica Interview Questions Click Here
Categories