Use Normalizer t/r, it convert column into rows,row into columns.

i want to convert below src into target

src is as follows
maths 30
science 20
social 81

i want data in trg like below

maths science social
30 20 81

Question Posted / amedela chandra sekhar

2 Answers
7825 Views
HCL, HP, I also Faced
E-Mail Answers

Answer Posted / amedela chandra sekhar

Use Normalizer t/r, it convert column into rows,row into
columns.

Is This Answer Correct ?

2 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

9141

Explain dynamic target flat file name generation in informatica

1055

How do you load first and last records into target table?

1159

What are the tasks that can be performed using sq?

1093

Explain what transformation and how many are there in informatica?

959

can anyone explain me about retail domain project in informatica?

7948

How to join three sources using joiner?

1116

can we override a native sql query within informatica? How do we do it?

1127

What are the informatica performance improvement tips

1094

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2172

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2004

What are the databases that informatica can connect to windows?

1054

How do you convert single row from source into three rows into target?

1157

What is deployment group?

1216

Design a mapping to load a target table with the following values from the above source?

1347