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 the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

What is polling in informatica ?

1 Answers   TCS,

---

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

---

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

---

What is the difference between view and materialised view?

4 Answers  

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---