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
- 11800 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivas
dataflow
FF-----> Sourcequalifier...>aggregatore T/F....>target
in aggregator transformation add three new ports
o_col1,0_col2,o_col2 and make output ports
and expression in out ports
o_col1-----MAX(col1),
o_col2-----Max(col2),
o_col3-----Max(col3);
and connect these output ports to target
you will get the resul
| Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
How to extract sap data using informatica? What is abap? What are idocs?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the uses of etl tools?
What is dynamic cache?
explain abt ur project architecture?
What is meant by LDAP users?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Why update strategy and union transformations are active?
is it possible to index the data in cache of lkp transformation ?
Explain in detail about scd type 1 through mapping.
Explain load alternative records / rows into multiple targets - informatica
What is a grid in Informatica?
What's the layout of parameter file (what does a parameter file contain?)?
