Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7365 Views
- Ness Technologies, I also Faced
- E-Mail Answers
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
Why update strategy and union transformations are active? Explain with examples.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is transformation?
Explain the different lookup methods used in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain dynamic target flat file name generation in informatica
According to his methodology what all you need before you build a datawarehouse
What is mapping debugger?
What is a joiner transformation?
How do you load alternate records into different tables through mapping flow?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is event and what are the tasks related to it?
What is informatica? Why do we need it?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
The question was on time stamp. what is the difference between HH and HH24 when to use when.
