followin source like region sales 1 100 2 200 i want the output

followin source like

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

Question Posted / dinesh

2 Answers
5888 Views
Oracle, I also Faced
E-Mail Answers

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

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers IBM,

can u give example for factless fact table

2 Answers TCS,

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers IBM,

Different types of Power center errors?

1 Answers Cinterco, IBM,

What is confirmed dimension and fact?

7 Answers

how do u get the first record from 50,000 records ?

10 Answers TCS, UBS,

What is the difference between a table and the materialized view?

2 Answers

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers IBM,

Explain your project of banking domian.