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.

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

---

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

When do you use sql override in a lookup transformation?

0 Answers  

---

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  

---

What is Micro Strategy? Why is it used for?

5 Answers   Infosys,

---

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---