Answer / dev

Have index on the sources and make sure indexes are dropped in target(any ways these are distinct records) before load and opt for bulk loading. Once load is done you can create thee indexes again and maybe analyze the table also.

Answer / guest

Partition

Answer / nitin tomer

1) Load Data using Bulk Load for that we have to drop index from the target table, but after loading the data to create the index will also take good amount of time
2) Create a sequence 1 to 100 million using sequence generator and create the pass-through partition to load data, let say 10 partition we can create from 1 to 100000 like that.

Partitioning will definitely give huge performance improvement.

What are the different types of schemas?

11 Answers   ITC Infotech,

---

What is primary and backup node?

0 Answers  

---

What is the advantage of informatica?

0 Answers  

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

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

0 Answers  

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

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??

0 Answers  

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

how to declare array in plsql?

1 Answers  

---

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---

Describe data concatenation?

0 Answers  

---

What is factless fact schema?

1 Answers  

---