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
- 6992 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 |
What is the filename which you need to configure in UNIX while installing infromatica?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
What are the reusable transformations?
How to convert multiple rows to single row (multiple columns) in informatica
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
How is union transformation utilized?
what is session parameters?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
Explain the scenario which compels informatica server to reject files?
Kimball and Inmon methodologies?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
Teradata 
