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
- 6631 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
What are the reusable transformations?
How to create or import flat file definition in to the warehouse designer?
State the limitations where we cannot use joiner in the mapping pipeline?
Enlist few areas or real-time situations where informatica is required.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Write the unconnected lookup syntax and how to return more than one column.
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is a difference between complete, stop and abort?
What are the performance considerations when working with aggregator transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
where to store informatica rejected data?
What are the different options available for update strategy?
What is a shortcut and copy in Informatica and how two are different with each other?
How do you convert single row from source into three rows into target?
What are the tasks that source qualifier perform?
