followin source like

region sales
1 100
2 200
i want the output following format
region 1 2
sales 100 200

Answers were Sorted based on User's Feedback



followin source like region sales 1 100 2 200 i want the output following format re..

Answer / lakshman

normalisation t/r

Is This Answer Correct ?    0 Yes 0 No

followin source like region sales 1 100 2 200 i want the output following format re..

Answer / sree

use java Transformation(through code we can solve this)

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Informatica Interview Questions

WAT IS TEXT LOAD?

3 Answers   Wipro,


i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  


What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  


"Change cache" in Informatica ?

2 Answers  


What is the meaning of up gradation of repository?

1 Answers  


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1 Answers  


Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,


What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,


What is the surrogate key?

1 Answers  


The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,


I have a flat file, want to reverse the contents of the flat file

1 Answers   Informatica,


What is informatica worklet?

1 Answers  


Categories