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

we have three columns and two rows.
col1 col2 col3
a b c
want to change into 2 columns and 3 rows ,how?
col1 a
col2 b
col3 c
which transformation u'll use and how?

Question Posted / minisweet85

Answers were Sorted based on User's Feedback



we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns a..

Answer / sbvprasad

by using normalizer T/r u can do the above logic

Is This Answer Correct ?    8 Yes 0 No

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns a..

Answer / abhishek kumar(abhisheklalmca@

src->sq->normalizer->expression->target
In normalizer--
c1(column name)- 3(occurs)-string(datatype)

In Expression--

o_c1 -(output port)
decode(GCID_c1,1,'col1',2,'col2',3,'col3')

connect
o_c1(expression) to c1( target port)
c1(exp) to c2(target) port
target should be like this
C1 C2
---------- -----
col1 a
col2 b
col3 c


thanks
abhishek

Is This Answer Correct ?    6 Yes 0 No

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns a..

Answer / ravi

USE NORMALIZER TRANSFORMATION

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is fact table?

9 Answers  

What are the join types in joiner transformation?

1 Answers   Informatica,

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

What are roles and groups and benefits of using them?

0 Answers  

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

EXL informatica Questions

0 Answers  

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

What are conformed dimensions?

1 Answers  

What is primary and backup node?

0 Answers  

For more Informatica Interview Questions Click Here
Categories