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
- 11576 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
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 |
Answer / suri
thats a oracle answer
but in informatica u have to use reverse pivoiting
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / maheshkumar bvn
first convert flat file to oracle table
create table num_test(field1 int,field2 int,field3
int,field4 int);
insert into num_test values(1000,null,null,null);
insert into num_test values(null,2000,null,null);
insert into num_test values(null,null,3000,null);
insert into num_test values(null,null,null,4000);
select max(field1),max(field2),max(field3),max(field4) from
num_test;
result:
1000 2000 3000 4000
| Is This Answer Correct ? | 7 Yes | 8 No |
Answer / jayesh
Filter in source qualifire itself..in sq query or sq filter.
| Is This Answer Correct ? | 0 Yes | 5 No |
What is the difference between informatics 7x and 8x and what is latest version?
Limitation of REPLACESTR. Is there any character limitation to it.
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
Explain informatica architecture - version 8 / 9
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
HOW TO GET THE LATEST DATA IN SCD ?
Why we use stored procedure transformation?
Explain sessions?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
why dimenstion tables are denormalized in nature ?
What is metadata reporter?
Teradata 
