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 the complex transformation you used in informatica

0 Answers   TCS,

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,

What is the Difference between sorter and aggregator?

2 Answers  

Design time, run time. If you don't create parameter what will happen

0 Answers  

how to get the first row without using rank t/r?

7 Answers   iGate,

what are the types of facts with Examples?

3 Answers  

Clarify the utilization of aggregator cache record?

0 Answers  

What is power play plug in?

2 Answers  

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories