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
- 7633 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 many ways are there to create ports?
What are the restrictions of union transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the tasks that source qualifier perform?
Which transformation is needed while using the Cobol sources as source definitions?
What does command task mean?
How might one distinguish in the case of mapping is right or not without associating session?
What are the issues you have faced in your project? How did you overcome those issues?
What the difference is between a database, a data warehouse and a data mart?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
how to load rows into fact table in data warehouse
What is a predefined event?
Suppose we do not group by on any ports of the aggregator what will be the output?
In how many ways we can create ports?
What if the source is a flat-file?
