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
8846 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

More Informatica Interview Questions

How to recover sessions in concurrent batches?

3 Answers

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers

How to extract original records at one target & Duplicate records at one target?

12 Answers

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers IBM,

What are the various types of transformation?

0 Answers

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers HP,

what we require for D.modelling?

1 Answers

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers iGate,

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers Informatica,

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers

Are there any types of Dynamic Caches in informatica

4 Answers Accenture,

For more Informatica Interview Questions Click Here