Answer / somu

A Datawarehouse is a database.It has some Characteristics.Those characteristics database is known as Datawarehouse. these characteristics are subject oriented,time varint,non-volatile,integrated.

Answer / azeez

A datahouse is subject oriented . combination of diffeent
datamarts

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

---

How to recover sessions in concurrent batches?

3 Answers  

---

How will you combine 3 different sources with a single source?

3 Answers  

---

What is meta data and system catalog?

2 Answers  

---

---

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

---

How many repositories can we create in Informatica?

3 Answers  

---

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

---

Differentiate between sessions and batches?

0 Answers  

---

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,

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---