Answer / rajeshkumar

A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts. Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table.

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

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

0 Answers   IBM,

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---

What is meant by incremental aggregation?

0 Answers  

---

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

What are the joiner caches?

3 Answers   Informatica,

---

what is scd?

6 Answers  

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

How to update a particular record in target with out running whole workflow?

0 Answers  

---