Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6701 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivas
Just load the flat file.
(1000,null,null,null
null,2000,null,null
null,null,,3000,null
null,null,null,4000)
Go with Aggregate Trans formation with
MAX(field1)
MAX(field2),,,, .
Pls let me know if any corrections srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Define enterprise data warehousing?
What is main use of mapplet?
Why do we need informatica?
Which development components of informatica have the highest usage?
How we can use union transformation?
What can we do to improve the performance of informatica aggregator transformation?
What are the new features of informatica 9.x in developer level?
What is union transformation in informatica?
What is a dimensional model?
difference between repository database and repository service?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the informatica performance improvement tips
What are the types of caches in lookup? Explain them.
What are the components of Informatica? And what is the purpose of each?
Which means the first record should come as last record and last record should come as first record and load into the target file?
