thats a oracle answer but in informatica u have to use reverse pivoiting

I am having a FLAT FILE SOURCE as first line:
1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
null,null,null,4000 ............................Now i want
the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For
more clarification i
want to elimate nulls and want in a single line. Please
help me out

Question Posted / suri

5 Answers
11799 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / suri

thats a oracle answer
but in informatica u have to use reverse pivoiting

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define sessions in informatica etl?

1038

What is substr in informatica?

1210

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

What is informatica powercenter repository?

1204

What is the command used to run a batch?

1066

What is workflow manager?

1053

Is there any target staging area in informatica not staging area

2580

How to extract the informatica rejected data?

1223

Is it possible to use a client with different version than that of its Informatica server?

1148

What do you understand by term role-playing dimension?

1048

What does command task mean?

1155

What all join we can perform in LOOKUP transformation?

978

What is dimensional table?

1069

What is the difference between Active and Passive transformation?

1152

What is rank transformation in informatica

1179