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
- 9861 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
How to do unit testing in informatica?
Explain your project of banking domian.
Is it possible to create multiple domains on a single Informatica server?
Define enterprise data warehousing?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a pre-defined event and user-defined event?
Explain the types of transformations?
Is there any way to read the ms excel datas directly into informatica?
explain one complex mapping with logic? sales project?
What is informatica worklet?
Write the prerequisite tasks to achieve the session partition?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to create a non-reusable instance of reusable transformations?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the need of an ETL tool?
