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
- 11792 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
While migrating the data from one environment to another environment how would you manage the connections?
How to create or import flat file definition in to the warehouse designer?
To import the flat file definition into the designer where should the flat file be placed?
Partition, what happens if the specified key range is shorter and longer
Differentiate between a repository server and a powerhouse?
What is sequence generator transformation in informatica?
What are session parameters ? How do you set them?
What are the different components of powercenter?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to call shell scripts from informatica?
What are the types of lookup transformation?
how to load rows into fact table in data warehouse
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is rank index in rank transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
