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
- 6987 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 |
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
how many types of dimensions are available in informatica?
what is left outer join?
What is the meaning of decode in informatica?
What is a command that used to run a batch?
Differentiate between Load Manager and DTM?
what is the use of Java Transformation in Informatica 8.x?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
can anyone explain me about retail domain project in informatica?
How many numbers of sessions can one group in batches?
Teradata 
