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.

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

What will be the approach?

0 Answers  

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

what is the look up transformation?

2 Answers   Informatica,

---

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

---

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

Whats the difference between $, $$, $$$

9 Answers  

---

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

---

How do you set a varible in incremental aggregation

0 Answers  

---

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,

---