Answer / upender

Bulk mode option used to load huge data.
normal mode option used to load small amount of data like
less than 1000 to 10000 records. It will fail, if you use
bulk mode option, loaded just 1 or 2 records.

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

what is incremantal aggregation?

1 Answers  

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

What is router transformation

4 Answers   CSC,

---

what is junk dimension

4 Answers   Cap Gemini,

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

---

What is the need of building a data warehouse?

2 Answers  

---

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

---

What is the command used to run a batch?

0 Answers  

---

How to do unit testing in informatica?

0 Answers  

---

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---