i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow
Answer Posted / vani
Can it be done in this way....
1)Drag source to mapping designer
2)Take a router transformation .consider EMP table in which
i am using EMPNO. In group1, assign the condition as
mod(empno,2)=0 which gives even numbers and in group2,
assign the condition as mod(empno,2)!=0 which gives odd numbers.
3)connect group1 to one target and group2 to another target.
If i am wrong please tell me....
Is This Answer Correct ? | 27 Yes | 4 No |
Post New Answer View All Answers
How might one distinguish in the case of mapping is right or not without associating session?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How can you define user defied event?
What is lookup change?
Briefly describe lookup transformation?
What are ETL Tools?
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 the status code in stored procedure transformation?
Why update strategy and union transformations are active? Explain with examples.
Enlist the various types of transformations.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is xml source qualifier transformation in informatica?
What can we do to improve the performance of informatica aggregator transformation?
tell me the rules and responsblites in our project(my project is development)