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 |
Scheduling properties,whats the default (sequential)
What are variable ports and list two situations when they can be used?
Explain lookup transformation is active in informatica
Where can we find the throughput option in informatica?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
What is rank transform?
how do u move the code from development to production?
what is the dashbords?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties