Just load the flat file. (1000,null,null,null null,2000,null,null null

I am hvaing 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 For more clarification i
want to elimate nulls and want in a single line. Please
help me out

Question Posted / srinivas

2 Answers
6837 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / srinivas

Just load the flat file.
(1000,null,null,null
null,2000,null,null
null,null,,3000,null
null,null,null,4000)
Go with Aggregate Trans formation with
MAX(field1)
MAX(field2),,,, .

Pls let me know if any corrections srinu.srinuvas@gmail.com

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the aggregator transformation?

1219

Clarify the utilization of aggregator cache record?

1042

What are the uses of etl tools?

1175

What are the components of the workflow manager?

1179

COM components can be used in Informatica

2450

What are the differences between a connected lookup and unconnected lookup?

1122

Briefly define a session task?

1191

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2576

Is it possible to create multiple domains on a single Informatica server?

1286

tell me 5 session failure in real time how can you solve that in your project?

2388

What is intricate mapping?

1308

Name the different lookup cache(s)?

1292

How to generate sequence numbers?

1129

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2121

What is olap (on-line analytical processing?

1109