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
- 11821 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 |
how can you load data into target table without leading zeor's
What's the layout of parameter file (what does a parameter file contain?)?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are different types of transformations available in informatica?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
What are the tuning techniques you applied during your last project
what is diff between IN and EXIT commands
How to prepared lld.can any one tell me detailed explanetion.
what is INFORMATICA TESTING process
How can u stop a batch?
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?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
Teradata 
