Loading data to multiple targets

How to create mapping that half records will go to one target and half to another target?

Questions by chandu.sarisa

Showing Answers 1 - 9 of 9 Answers

1.Use SQ Override and get Rownum and link to a integer column in source.
2.In expression editor implement the logic that how many number of rows to be grouped
3.Use Router transformation to load the results into target tables.

  Was this answer useful?  Yes

sivakp

  • Mar 13th, 2011
 

Create two source qualifier write a query in SQL override

select * from emp where rownum in
(select count(*)/2 from emp)

another
SQL override write a query

select * from emp
minus
select * from emp where rownum in
(select count(*)/2 from emp)

To connect target

  Was this answer useful?  Yes

Use the sql override in source qualifier as select col1, col2, (select count(*) from table) from table;

In the mapping flag the rows into groups in router t/f as count(*) port <= count(*)/2 and count(*) port > count(*)/2

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions