Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
- 3 Answers
- 7903 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
What is Session and Batches?
Difference between task flow and linear task flow
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
how to design mapping half of source table records into one target and remaining half into another target
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
need for registering a repository server
what is worklet and what use of worklet and in which situation we can use it?
Which transformation should u need while using the cobol sources as source defintions?
What are events in workflow manager?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
What is meant by lookup transformation? Explain the types of lookup transformation?
Teradata 
