Answer / s

INPUT
col1 col2
101 1000
101 1500
101 2000
102 1200
102 2300
102 3000
103 2400
103 1300
103 2000

OUTPUT
col1 col2
101 1000,1500,2000
102 1200,2300,3000
103 2400,1300,2000


SOURCE->SRT->EXP->TGT

SRT - Sort by column col1.
EXP - col1
col2
v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_col1=col1
o_col1=v_col1
o_col2=v_col2

Answer / john coder

i believe, we need an aggregator to pick up the last row for
a particular deptno.

Otherwise, there will be three rows inserted...

col1 col2
101 1000
101 1000,1500
101 1000,1500,2000

by having an aggregator with groupby on col1, we can pick up
the last row by either using LAST or MAX.

Answer / balaganesh

SQ-->SRT-->EXP-->AGG-->TGT

In SRT:
sort the record by col1 (Ascending)

In Exp:
col1
col2

v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_maxcount=iif(v_col1=col1,v_maxcount+1,1)
v_col1=col1
o_col1=v_col1
o_col2=v_col2
o_maxcount=v_maxcount

In AGG:
Group by o_col1
MAX(o_maxcount)

Answer / venky

src->exp->agg->tgt

exp transformation

col1
col2
var1=iff(var2=col1,var1||','||col2,col2)
var2=col1
output=var1

agg transformatiom

col1 select group

Answer / anoymous

If the source is Relational then source qualifier can be
overridden

Select Col1, Concat('col1',',','col2') from table name
groupby col1;

Answer / kiran

USE SOTER TR . IN SORTER TR CLICK ON DISTINCT OPTION IT ELIMINATE THE DUPLICATE AS WELL AS SORT THE ORDER.

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

why we r using presql&postsql in source qualifier?

1 Answers   HP,

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

tell me the rules and responsblites in our project(my project is development)

0 Answers  

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

how can u approach u r client

2 Answers   CTS,

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

Explain lookup transformation source types in informatica

0 Answers   Informatica,

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,