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

If informatica has its scheduler why using third party scheduler?

1196

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

971

---

What can we do to improve the performance of informatica aggregator transformation?

1045

---

What are the tasks that can be performed using sq?

1026

---

To import the flat file definition into the designer where should the flat file be placed?

1008

---

what are 3 tech challenges/ common issues you face?

2282

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2182

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2470

---

Define mapping and session?

973

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1998

---

Repository user profiles

1715

---

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

2081

---

Explain the code page compatibility?

1022

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7072

---

Different sorts of metadata that stores in the storage facility?

948

---