Answer / vaibhav bhandeo

Datamart is a subset of data warehouse and it supports a
particular region, business unit or business function.
Data warehouses and data marts are built on dimensional
data modeling where fact tables are connected with
dimension tables. It is designed for a particular line of
business, such as sales, marketing, or finance.

Answer / amedela chandra sekhar

Data mart is a subset of Data warehouse.it is a complete information about one particular domain.eg:(finance,sales).

Data marts and Data warehouses are built on dimensional
data modeling where the relationship b/w dimension tables fact tables.

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

---

guys which is the best institute in banglore to learn informatica??

2 Answers  

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

How to delete the data in the target table after loaded.

3 Answers   TCS,

---

what is difference between COM & DCOM?

1 Answers   Satyam,

---

What is source qualifier?

6 Answers   SDS,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

Explain the different lookup methods used in informatica?

0 Answers  

---

What are junk dimensions?

0 Answers  

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---