In the lookup transformation->properties->presql condtion write del

I am hvaing SOURCE as
1000,null,null,null
null,2000,null,null
null,null,3000,null
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 / madhavi

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

Answer Posted / madhavi

In the lookup transformation->properties->presql condtion
write delete from table_name where column_name="NULL";.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the limitations of joiner transformation?

1044

Define update strategy?

1112

where to store informatica rejected data?

1046

What are the different components of powercenter?

986

What is a rank transform?

1024

What are the tasks that can be performed using sq?

1024

What is workflow? What are the components of workflow manager?

1119

What is meant by lookup transformation? Explain the types of lookup transformation?

899

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1506

State the differences between sql override and lookup override?

1113

Can u generate reports in Informatica?

1025

How to delete duplicate row using informatica?

982

What are data-driven sessions?

1143

Enlist the differences between database and data warehouse.

1033

What is the need of an ETL tool?

1027