we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
Answer Posted / pavan
using Router transformation we can solve this.
create as many conditions u want.
Suppose,if rownum=2 then flow the data to target 1
if rownum=5 then flow to another target
go on....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the static cache and dynamic cache in informatica?
What is the need for an etl tool?
What are the new features of informatica 9.x in developer level?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can we create two repositories on same database instance in oracle?
Explain the informatica workflow?
What is the benefit of session partitioning?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the new features of informatica 9.x developer?
Global and Local shortcuts. Advantages.
Define joiner transformation?
How can we use mapping variables in informatica?