how can we convert a column into row in informatica? Eg: INPUT- a x Output Li

how can we convert a column into row in informatica?
Eg: INPUT- a x Output Like: a b c
b y x y z
c z

Question Posted / kumar

3 Answers
14481 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c ..

Answer / sunil

column in to row can be converted by using Normalizer
transformation

Is This Answer Correct ?

16 Yes

11 No

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c ..

Answer / babu

Hi Sunil please give detailed expalnation of the above
logic and dfd(data flow diagram ).

Is This Answer Correct ?

5 Yes

0 No

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c ..

Answer / lv

src--agg--exp--exp--jnr--tgt

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

how the informatica server sorts the strings values in rank transformations?

3 Answers TCS,

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers CSC,

what is metadata?

8 Answers Satyam,

How you prepared reports for OLAP?

0 Answers

What are the tasks that can be performed using sq?

0 Answers

Could you explain what is enterprise data warehouse?

0 Answers

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers

What are the two modes of datamovement in informatica sever?

2 Answers

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers Cognizant, emc2,

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers IBM,

How are parameters defined in informatica?

3 Answers HP, TCS,

How to generate the HTML output using Informatica.

3 Answers Wipro,

For more Informatica Interview Questions Click Here