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
- 8155 Views
- IBM, I also Faced
- E-Mail Answers
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
How can you define user defied event?
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 do you load alternate records into different tables through mapping flow?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
According to his methodology what all you need before you build a datawarehouse
Different circumstance which drives informatica server to expel records?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the difference between informatica 7.0 and 8.0?
What is option by which we can run all the sessions in a batch simultaneously?
What do you understand by SOA of Informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Define filter transformation?
Differentiate between router and filter transformation?
How to do unit testing in informatica? How to load data in informatica ?
How might you approve all mappings in the archive all the while?
