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.

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

what is fact table?

9 Answers  

---

how to we create datamart?

2 Answers   HSBC,

---

where to store informatica rejected data?

0 Answers  

---

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

what is difference between mapping and mapplet ?

2 Answers   TCS,

---

what is SDLC way of code development?

0 Answers  

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---