give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

0 Answers   HCL,

---

What is data modeling and data mining?

0 Answers  

---

Explain the use lookup tables and Aggregate tables?

0 Answers  

---

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

1 Answers   IBM, Saama Tech, Wipro,

---

what is the meant by Normalization and de-normalization?

0 Answers  

---

---

how do u set the size of block buffer?

1 Answers  

---

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  

---

when will use SQL override in a lookup transformation?

0 Answers  

---

how do u implement scheduling in Informatica?

1 Answers   Cognizant,

---

What are the types of Data Warehouse applications?

0 Answers  

---

What are materialized views & where do we use them?

0 Answers  

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  

---