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
- 8163 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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
r u done any partitions in ur project?
What is mapplet in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Different circumstance which drives informatica server to expel records?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to partition the Session?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are Dimensional table?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
EXL informatica Questions
Explain how many types of dimensions are available in informatica?
