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
- 9672 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / adisekhar
FROM THE ABOVE ANSWER WE HAVE TO ADD NORMALIZER TRANSFORMATION
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What differs when we choose the sorted input for aggregator transformation?
Have you worked with/created Parameter file
What is a predefined event?
What is a repository? And how to add it in an informatica client?
What is informatica powercenter repository?
Explain lookup transformation in informatica
What is dynamic cache?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How can we improve session performance in aggregator transformation?
Write the advantages of partitioning a session?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to update a particular record in target with out running whole workflow?
How can we use mapping variables in informatica? Where do we use them?
Which are the different editions of informatica powercenter that are available?
What are ETL Tools?
