Answer Posted / john

Generally we all knew that is,In Datawarehouse
environment,we should load data first in the dimension
table then we load into the fact table..bcoz fact table
which contains the Primary keys of the dimension table
along with the measures.
So we need to check first that whether the fact table which
you are going to load that has foreign key relationship
with the dimension table or not?If yes,Use pipeline mapping,
and load dimension data first in first pipeline and in the
second pipeline load fact table data by taking the lookup
transformation on the dimension table which has loaded data
already..and return the key value from the lookup
transformation then calculate the measures by using
Aggregator and also give "group by" on the dimension keys
and map to the Target(Fact) prots as required.
most importantly specify the "Target Load Plan"
where dimesion target as first,fact table target as second.
let me pls correct my answer If i am wrong..

What is blocking transformation?

1187

---

What is data transformation manager process?

1220

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2198

---

have u done any performance tuning? how u ll do?

2363

---

What is the fact table?

1132

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1140

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2186

---

What is lookup transformation?

1092

---

Describe data concatenation?

1123

---

How do you load only null records into target?

1251

---

What are the types of caches in lookup? Explain them.

1009

---

What is the maplet?

1202

---

Could you explain what is enterprise data warehouse?

1224

---

How will the document be delivered to me?

1129

---

What is meant by pre and post session shell command?

1199

---