A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  

---

Difference between flat files and relational sources?

0 Answers  

---

Define slowly changing dimensions (SCD)?

0 Answers  

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  

---

what are the reports developed in sap bw project and what is the requirement for developing it?

0 Answers   Maersk,

---

What do you understand by active and passive transformations?

0 Answers  

---

What is data cleaning?

0 Answers  

---

What is a staging area? What is the purpose of a staging area?

0 Answers  

---

Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,

---

Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  

---

What is a mapping?

0 Answers  

---

when will use SQL override in a lookup transformation?

0 Answers  

---