i have a source with 100 records.i have 2 targets.in the first
target i want to load first 50 records & in the second target
i want to load next 50(or remaining) records.
Answer Posted / kamleshmishra291
After SQ take expression and add port
v_Sequene=v_Sequence+1
o_Sequence=v_Sequence
Take Router Transformation and add two groups
Group1 = o_sequence<=50
Group2=o_sequence>50
Connect Group1 and Group2 to Target1 and Target2
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
Is it possible to define a single node as a Gateway node as well as worker node?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is meant by active and passive transformation?
Quickly characterize reusable change?
What are the differences between joiner transformation and source qualifier transformation?
What is confirmed fact in dataware housing?
What is standalone command task?
What are the new features of informatica 9.x developer?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
lookup transformation with screenshots
Where do we use mapping variables in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain the etl program with few examples.
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 .