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


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

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

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

How to create the source and target database connections in server manager?

0 Answers   Informatica,


write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,


How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,


if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,


How do you take back up of repository?

0 Answers  


How can informatica be used for an organization?

0 Answers  


How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,


Can we run session without using workflows?

5 Answers   TCS,


What is the need of an ETL tool?

0 Answers   Informatica,


What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,


what is flat file override?

1 Answers   Cap Gemini, HP,


What differs when we choose the sorted input for aggregator transformation?

0 Answers  


Categories