Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7951 Views
- I also Faced
- E-Mail Answers
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
How to differentiate between the active and passive transformations?
What is informatica powercenter repository?
difference between informatica 8.1.1 and 8.6
What are the main features of Oracle 8i with context to datawarehouse?
What is the use of code page?
Why sorter is an active transformation?
what is the difference between informatica6.1 and infomatica7.1
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Please let me know how to make encryption and decryption with example?
In which transformation you cannot drag ports into it?
What does command task mean?
How can we use batches?
