HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

0 Answers  

---

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  

---

list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  

---

what are business components in Informatica?

2 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  

---

Mention few test cases and explain them?

0 Answers  

---

what is the difference between cardinality and Nullability?

0 Answers  

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 Answers  

---

what is the use of server manager?

0 Answers  

---

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 Answers  

---

What are the steps involved in etl process?

0 Answers  

---