Answer Posted / 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.

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2224

---

How will the document be delivered to me?

1018

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1072

---

how to load rows into fact table in data warehouse

1114

---

What is decode in static cache?

1078

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6039

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1986

---

Which transformation should we use to normalise the COBOL and relational sources?

1141

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1985

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1628

---

What is a connected transformation?

1047

---

What is transformation?

1050

---

What is update strategy transform?

1015

---

Differentiate between source qualifier and filter transformation?

1509

---

Explain sessions?

978

---