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
- 9789 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
Explain Dataware house architecture .how data flow from intial to end?
What are the designer tools for creating transformations?
What is a stored procedure transformation?
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?
How many types of sessions are there in informatica.please explain them?
What are the popular informatica products?
How we can create indexes after completing the load process?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Sequence generator, when you move from develoment to production how will you reset
How to create Target definition for flat files?
What is the Process to creating lookup transformation in informatica
Explain about Informatica server process that how it works relates to mapping variables?
EXL informatica Questions
Can we create a Integration service without a Repository service and vice versa?
What is parallel processing in informatica?
