Interested to Buy Any Domain ? << Click Here >> for more details...
I am having a FLAT FILE 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 to a FLAT FILE only.For
more clarification i
want to elimate nulls and want in a single line. Please
help me out
- 5 Answers
- 11570 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sushma
FF ---> SOURCE QUALIFIER ---> EXPRESSION ---> AGGREGATOR ---
>TARGET FILE
In Expression TRFM,
a) for each column, create an expr to replace null values
with 0.
IIF(ISNULL(port_name),0,port_name)
b) create an output port (dummy_col) and set its value to 1
In Aggregator TRFM
a) Group by the dummy_col
b) for each of the 4 columsn, find the max value
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the benefit of session partitioning?
What is the need for an etl tool?
Differentiate between reusable transformation and mapplet.
In informatica workflow manager, how many repositories can be created?
How to use procedural logic inside infromatica?
What is Data Caches size?
How to load the data from people soft hrm to people soft erm using informatica?
wf dont have integration severances how you can run?
Differentiate between Load Manager and DTM?
What is update strategy transform?
What is xml source qualifier transformation in informatica?
What is the use of source qualifier?
write a query to retrieve the latest records from the table sorted by version(scd)
