Answer / james

Semi-additive facts are the measures in which they can be
added in some dimensions and cannot be added in some
dimensional tables.They are used in fact table loading.

Answer / ramana

The fact value decided by some of the dimensions values,then that fact is called semi additive fact.

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

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

4 Answers  

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

What is the surrogate key?

0 Answers  

---

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---