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 |
what is diff b/t sorter t/r and agg have the option sorter property...
What you know about transaction control transformation?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
where does the default group roew in a router is stored what is the default size of memory in router
Please let me know how to make encryption and decryption with example?
how do u tune queries?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
Without using Lookup & Sequence Generator, How to generate Sequence?
how to obtain performance data for individual transformations.
In informatics server which files are created during the session rums?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,