I have a scenario which load the data frm single source to
2 targets as T1, T2, and T1 have a P.K and T2 have F.K
relations. first data has to load in T2, and then data load
to T1 if that record exist in T1... how can we acheive it?
Answer Posted / babu
Hi raviKumar,
I think u r question has small mistake that is first data
has to load in T1 then only load T2.
By using "Constraint Based load ordering" option u can
achieve this.This option is available in 'Config object'
tab in Session Tabs
(General,Properties,Config
objects,Mapping,Components,Metadata Extensions)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is blocking transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How do you update the records with or without using update strategy?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
I have a flat file, want to reverse the contents of the flat file
What does command task mean?
What you know about transaction control transformation?
what is mean by complex business rule ?
What is a router transformation?
What is the meaning of up gradation of repository?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Different circumstance which drives informatica server to expel records?
What is the command used to run a batch?
Can we get 1st record through Informatica(without sequence number).