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
What are the steps involved in the migration from older version to newer version of Informatica Server?
Can you use flat files in Mapplets.
Explain in detail scd type 2 through mapping.
Explain the mapping variable usage example in informatica
Define mapping and session?
What is informatica worklet?
What are the new features of informatica 9.x in developer level?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to do unit testing in informatica? How to load data in informatica ?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
where to store informatica rejected data?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to configure mapping in informatica?
What is the function of union transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?