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
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 a poling?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
What are connected or unconnected transformations?
what is degenerated dimension?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Can you use flat files in Mapplets.
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
Can we change Dynamic to Static or Persistent cache? If so what happens?
State the differences between sql override and lookup override?
How to load last 10 records of flat file in to the target?