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
- 6583 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
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How can we use batches?
What is incremental aggregation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is the maplet?
What is the advantage of informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is a filter transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
design of staging area?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
