Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6843 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
Briefly describe lookup transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How does a sorter cache works?
What is the command used to run a batch?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
In development project what is the process to follow for an etl developer from day1
what is diff b/t sorter t/r and agg have the option sorter property...
What is enterprise data warehousing?
What is xml source qualifier transformation in informatica?
What is a node in Informatica?
What is union transformation?
What is decode in static cache?
Mention a few design and development best practices for informatica?
explain one complex mapping with logic? sales project?
What do you understand by SOA of Informatica?
