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
Answer Posted / arunakumari l
let us take column names as col1,col2,col3,col4
STEP1:Add normalizer and place occurs value as 4
STEP2:use filter to eliminate null values
STEP3:take expression transformation and use concat
function to concatenate row values
i think this might work
tell me if i am wrong
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Implementation methodology
What is workflow? What are the components of workflow manager?
What is a dimensional model?
Where can we find the throughput option in informatica?
What is an unconnected transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain the aggregator transformation?
Is it possible to revert a global repository to local one and why?
Mention some types of transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is dimensional table? Explain the different dimensions.
What's the layout of parameter file (what does a parameter file contain?)?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is transformation?