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 do u do when DB time takes more?in sap bi

0 Answers  

---

What is virtual Data Warehousing?

0 Answers  

---

what are variable ports and list two situations when they can be used?

4 Answers   Satyam,

---

Define slowly changing dimensions (SCD)?

0 Answers  

---

How to Check the source record count from traget table.

5 Answers   IBM,

---

what is the difference between normal & bulk loading? and which one is recommended ? why?

2 Answers  

---

what types of repositories we can create in informatica? in real time in which type of repository we will work on?

2 Answers  

---

How can we use external procedural logic in informatica?

0 Answers  

---

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  

---

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,

---

what is the difference between OLTP database and data warehousing database?

4 Answers  

---