Answer / slim

its the difference between what is needed and what is
available...

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

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,

---

who to split dimentions into sub dimention

3 Answers   Wipro,

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

can we override a native sql query within informatica? How do we do it?

0 Answers  

---

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

what is confirmed fact?

2 Answers  

---

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

What is a repository manager?

0 Answers  

---