Answer / Prem Kumar Singh

A dimensional model is a data structure used for reporting and analysis purposes, where data is organized into dimensions (categories) and measures (quantities). It follows the star schema, with fact tables containing specific data points and dimension tables providing context.

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

---

What is workflow? What are the components of workflow manager?

1 Answers  

---

What is an unconnected transformation?

1 Answers   Informatica,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

What are some examples of informatica etl programs?

1 Answers  

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

How are the sources and targets definitions imported in informatica designer?

1 Answers   Informatica,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---