Interested to Buy Any Domain ? << Click Here >> for more details...
I am hvaing SOURCE as
1000,null,null,null
null,2000,null,null
null,null,3000,null
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
- 5 Answers
- 9668 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kondeti srinivas
it is so simple
write a query like this
SELECT MAX(A),MAX(B),MAX(C),MAX(D) FROM TABLE_NAME
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the new features of Power Center 5.0?
What is the cumulative sum and moving sum?
Can we override a native sql query within informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Global and Local shortcuts. Advantages.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is union transformation?
Differentiate between source qualifier and filter transformation?
What all are steps in up gradation of Informatica server?
What is a stored procedure transformation?
Make a note of the quantity vaults made in informatica?
What are the uses of etl tools?
What is the maplet?
