Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3

Question Posted / priya86.dwh

3 Answers
7964 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3 ..

Answer / anu

take sequence annd router t/r 's
connct nextval port to router

create one group mod(nextval , 2)=0-------target1
default group-----------------------------target2

this is applicable to above six source rows only

this is my second logic
tell me any corrections

Is This Answer Correct ?

7 Yes

3 No

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3 ..

Answer / anu

Select distinct in sorter t/r
then run session twice
but don't enable truncate option in session target properties

I think so
any corrections tell me

Is This Answer Correct ?

2 Yes

1 No

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3 ..

Answer / arjun

hi,
take aggrtr in that take one var , count the var group by i/p these go to one tgt and take another same tgt for that, take aggrtr ports i.e, i/p and var ports to filter in that give cndtion not isnull(var) and take i/p port to secnd tgt.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer