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
- 11795 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are some examples of informatica etl programs?
What do you mean incremental aggregation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is data caches/ index caches?
Define Pmrep command?
Explain in detail scd type 2 through mapping.
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain the difference between mapping parameter and mapping variable?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Write the unconnected lookup syntax and how to return more than one column.
Explain lookup transformation is active in informatica
What are the types of caches in lookup?
What are the uses of etl tools?
Explain why we use partitioning the session in informatica?
What is the need of an ETL tool?
