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
Answers were Sorted based on User's Feedback
select no,max(col1),max(col2),max(col3),max(col4) from
tablename group by no;
| Is This Answer Correct ? | 7 Yes | 0 No |
How to eliminate duplicates from flat file..what is the procedure
What is exclusive and normal mode for repository services?
what are the row and column separations in Flat Files
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
Explain incremental aggregation in informatica
What is an Integration service in Informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Can we call a stored procedure from a unix script which is run using command task
can we use cartesian join in informatica
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.