i have f;latfile source. i have two targets t1,t2. i want to load the odd no.o

i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow

Question Posted / guest

4 Answers
12335 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 an..

Answer / vani

Can it be done in this way....

1)Drag source to mapping designer
2)Take a router transformation .consider EMP table in which
i am using EMPNO. In group1, assign the condition as
mod(empno,2)=0 which gives even numbers and in group2,
assign the condition as mod(empno,2)!=0 which gives odd numbers.
3)connect group1 to one target and group2 to another target.

If i am wrong please tell me....

Is This Answer Correct ?

27 Yes

4 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 an..

Answer / sree

1. drag source and targets in to mapping designer work space
2. from t/r devoloper take sequence genarato t/r,exp t/r
and router t/r.
3. in seqg t/r give startvalue 1 ,increment by 1
give netval to a newpor in exp t/r
4. drag all ports of sq to exp in addition to newport
5. in router t/r create one group name as odd
give condetion mode(newport/2)!=0
6. give from group odd to t1
and defoult to t2.

Is This Answer Correct ?

6 Yes

0 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 an..

Answer / anand kumar

We can do this in the following.

Take the sequence generator t/r
set the properties like
Start value 1
End value 2
and also Enable cycle option

connect the nextval port to the router T/r
port "SGTNO"(created by you) and also connect the ports
from source qualifier to the router t/r

Now given the first condition like
SGTNO=1 then go to first target
otherwise go to second target(here no need to mention the
second condition).

If I went wrong, please let me know

Thanks
Anand Kumar

Is This Answer Correct ?

4 Yes

1 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 an..

Answer / sreekar

Hi,

Steps:-

1.Load ur source table into source analyzer.

2.generate the target tables.

3.in the maping designer take 2 filter transformations and
write these queries in each of the filter transformations

for even no of records:- select * from <tablename> where
(rowid,1) in (select rowid, mod(rownum,2) from <tablename>)

for odd no of records:- select * from <tablename> where
(rowid,0) in (select rowid, mod(rownum,2) from <tablename>)\

4. connect the output ports of this transformation to their
respective output tables.

Note:-
send your responses to suriaslesha_sreekar@yahoo.co.in

Is This Answer Correct ?

4 Yes

4 No

Post New Answer