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

hi all
my source looking like below
column1 column2
101,102,103 abc,def,ghi
1001,1002,1003 a,b,c


i want my target is

column1 column1
101 abc
102 def
103 ghi
1001 a
1002 b
1003 c


any one can you help

Question Posted / gangadhar799


hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 10..

Answer / fiero

Is the number of values in each column going to be a constant (i.e. 3 in this case)? If yes, there are couple of ways to do it.

Option 1:
Pass column 1 and 2 to an expression transformation.
Use string functions to determine the positions of commas in column 1 and store the values in individual output fields (e.g. 101 in field 1, 102 in field 2, etc). Do the same with the column 2 values.
Pass the individual o/p fields to a normalizer to transform the columns into rows.

Option 2:
Since the values are separated by comma, you can choose to write column 1 to a flat file target. Do the same with the column 2 values.
Then, use the files created from step 1 as CSV (delimited) file sources and use normalizer to transform them into rows.

Note: Normalizer will work only if the number of columns is known. If the number of columns can vary during run time, then you will have to think of something else.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

What will be the approach?

0 Answers  

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

How to elaborate tracing level?

0 Answers  

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

What is target designer and target load order?

0 Answers  

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

What is workflow manager?

0 Answers  

For more Informatica Interview Questions Click Here
Categories