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
- 5831 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 is Cognos script editor?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain the code page compatibility?
What are Dimensional table?
How to handle decimal places while importing a flatfile into informatica?
How many dimensions are there in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is the use of target designer?
How do you promote a non-reusable transformation to reusable transformation?
Explain the different kinds of facts.
can anyone explain me about retail domain project in informatica?
what are the deliverables?in your project?
Implementation methodology
Write the unconnected lookup syntax and how to return more than one column.
r u done any partitions in ur project?
