Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

Answers were Sorted based on User's Feedback



source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 30..

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

Is This Answer Correct ?    11 Yes 3 No

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 30..

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.

Is This Answer Correct ?    8 Yes 0 No

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 30..

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)

Is This Answer Correct ?    1 Yes 0 No

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 30..

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

Is This Answer Correct ?    0 Yes 0 No

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 30..

Answer / anoymous

If the source is Relational then source qualifier can be
overridden

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

Is This Answer Correct ?    0 Yes 4 No

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 30..

Answer / kiran

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

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

what is the exact meaning of domain?

3 Answers  


write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,


What is the term PIPELINE in informatica ?

7 Answers   Deloitte,


source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,


What are the differences between source qualifier and joiner transformation?

0 Answers  


How will you combine 3 different sources with a single source?

3 Answers  


What is difference between a gateway node and worker node?

0 Answers  


What is the difference between OLTP and ODS?

4 Answers  


What is rank index in rank transformation?

0 Answers  


How can repository reports be accessed without sql or other transformations?

0 Answers  


what is fact and what types of fact tables is there

4 Answers   Cap Gemini,


What is update override?

1 Answers   Accenture,


Categories