How to do Half of the table ex: if 1000 records are there means 500 in one table

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

Question Posted / narender.vankuri

2 Answers
7457 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second t..

Answer / narender.vankuri

Hi am Narender Reddy take an example:Dept table

Source->source Qualifier->After this we take one Aggregator and one Expression -> and both of this connected to Joiner -> this connect to Router->Here we take one Sequence generator and connect to Router-> this router connect to Targets

Here we see conditions:
1) In Aggregator create Cnt Port and(No input ,only output) There expression Condition(COUNT(DeptNo)
In this create One extra port Decimal express:1(no input,only output)
Disable Groupby
2) In Expression create one extra port decimal expression:1
this 2 transformations(Aggregator,Expression) are connected to Joiner
3)In Joiner Enable SorterInput,Condition And connect to Router Input.
4)Take one Sequence Generator and connect to Router Nextval
5)In Router Group1:Nextval<=(Cnt/2)
6)In Router Group2:Nextval>(Cnt/2)
7)Now connected to Traget1,Target2.

ThankYou
V.Narender Reddy

Is This Answer Correct ?

8 Yes

0 No

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second t..

Answer / vijaya

above answer only for the first time data loading only for new
record inserts to source it gives false results

Is This Answer Correct ?

1 Yes

4 No

Post New Answer