in which situations do u go for starflake schema ?

6 Answers   TCS,

---

What is synonym?

2 Answers   Patni,

---

how to create a sample mapping for dynamic lookup transformation

2 Answers  

---

what are objects in data warehouse?

2 Answers   Mind Tree,

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

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,

---

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

---

explain different types of modeling.

2 Answers  

---

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

---

What is a snowflake schema?

0 Answers  

---