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
- 11984 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 is an active transformation?
Explain the aggregator transformation?
How is union transformation utilized?
What if the source is a flat-file?
How to update a particular record in target with out running whole workflow?
What is the different lookup cache(s)?
What is Cognos script editor?
Which transformation is needed while using the Cobol sources as source definitions?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is size of u r database?
generate date / time dimension in informatica
During the running session, output files are created by informatica server. Enlist few of them.
What are the differences between a connected lookup and unconnected lookup?
Mention some types of transformation?
Why update strategy and union transformations are active?
