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

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

3 Answers
9560 Views
Cognizant, I also Faced
E-Mail Answers

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

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers IBM,

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers Amdocs,

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers HCL, Thomson Reuters,

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers CSC, iNautix,

What is the benefit of session partitioning?

0 Answers

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers Cap Gemini,

Hi experts, can anyone tell how much we use plsql in real time

3 Answers

What is an incremental loading? in which situations we will use incremental loading

2 Answers HCL,

What does command task mean?

0 Answers

What are multi-group transformations?

0 Answers Informatica,

For more Informatica Interview Questions Click Here