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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

i have source like
X1 10
X2 20
X1 30
X2 40

i want target as
X1 X2
10 20
30 40 in informatica

Question Posted / ajit_nitr

Answers were Sorted based on User's Feedback



i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informat..

Answer / raji

Well,As of my knowledge.....
first u have to take eliminet the duplicates.....like
SRC---->SQ--->AGG---->TGT
in aggr t/f give the group by for both ports...
after this step just use a normalizer t/f to convert these
rows in to columns...

Is This Answer Correct ?    2 Yes 0 No

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informat..

Answer / sushma

SOURCE--->SOURCE QUALIFIER ----> EXPTRANS1 -----> FILTER ---
--> EXPTRANS2 ------> TARGET

In EXPTRANS1, concatenate X1 and X2 values for every 2nd
record (ie X= X2). Lets call this output column as
x1x2_value
Note: I am concatenating for every second record as X1 and
X2 appear alternatively In your sample data,

In the filter transformation, have the filter condition
X='X2' (only these recs have the concatenated data)

In EXPTRANS2, Using substr to split the data into X1 and X2
and load it into target table

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More Informatica Interview Questions

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

can we override a native sql query within informatica? Where do we do it?

0 Answers  

what is the function of 'F10' informatica ?

4 Answers   IBM,

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

Can a joiner be used in a mapplet.

1 Answers  

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories