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
- 5 Answers
- 8162 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
Explain the types of lookup transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How do we call shell scripts from informatica?
What is a filter transformation and why it is an active one?
which one is better performance wise joiner or look up
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Differentiate between sessions and batches?
Explain the tuning lookup transformation - informatica
What is the function of look up transformation?
Define pmcmd command?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How union transformation is used?
