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
- 6902 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 |
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
What are the joiner caches?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
Can you access a repository created in previous version of Informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what is system requirement(SR) & business requirement(BR)?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
what is the dashbords?
How to extract sap data using informatica? What is abap? What are idocs?
What is predefined event?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
Teradata 
