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 scenario which compels informatica server to reject files?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is an Integration service in Informatica?
What is a code page?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the new features of informatica 9.x in developer level?
What are the different ways to implement parallel processing in informatica?
Explain the types of transformations?
What is the format of informatica objects in a repository?
What is union transformation in informatica?
Informatica Checkpoints
Explain the different kinds of facts.
What is the advantage of informatica?
What is the difference between Active and Passive transformation?