Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 12319 Views
- Wipro, I also Faced
- E-Mail Answers
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 different types of transformation available in informatica. And what are the mostly used ones among them?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is transformation?
Define mapplet?
Explain the tuning lookup transformation - informatica
How to delete duplicate row using informatica?
What is union transformation?
Which is the t/r that builts only single cache memory?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is intricate mapping?
Explain the shared cache and re-cache?
How to open an older version of an object in the workspace?
What is an Integration service in Informatica?
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 .
Difference between Target-based loading and constraint-based loading?
