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
- 2 Answers
- 5829 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / durgaprasad
select no,max(col1),max(col2),max(col3),max(col4) from
tablename group by no;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the Process to creating lookup transformation in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is an active transformation?
EXL informatica Questions
In which transformation you cannot drag ports into it?
What do think which one is the better joiner or look up?
What are mapplets? How is it different from a Reusable Transformation?
How to delete duplicate row using informatica?
How to join three sources using joiner? Explain though mapping flow.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the meaning of decode in informatica?
Mention few advantages of router transformation over filter transformation.
What are the types of data warehouses?
What is the difference between informatica 7.0 and 8.0?
how to create user defined function (udf) in informatica
