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

After we make a folder shared can it be reversed?Why?

2 Answers Accenture,

how we can load rejected record's at run time?(not through bad files)

0 Answers TCS,

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers TCS,

How can we update a record in the target table without using update strategy?

0 Answers

How to load duplicate records in to a target table which has a primary key?

2 Answers

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers Accenture,

What is CDC? How to implement CDC?

4 Answers People Tech, TCS,

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers Bank Of America,

How can we use mapping variables in informatica?

0 Answers

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers Cap Gemini,

What is Factless fact table ???

12 Answers Satyam, Tech Mahindra,

For more Informatica Interview Questions Click Here