Answer Posted / satya

Hi All,

If anyone have informatica dumps for developer certification, please forward to my mail. My email id is 'dt.satyam@gmail.com'

Thanks & Regards
Satya

How to fine tune mappings?

997

---

Explain do we need an etl tool?

1074

---

Define Dynamic push down optmization?

2348

---

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1865

---

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?

1918

---

Difference between flat files and relational sources?

2367

---

Compare ETL & Manual development?

997

---

how would u estimate the size of Lookup transform data and index cache?

2189

---

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2254

---

Can we create Hierarchies in generic datasources?

2427

---

if i have a query as flat file how can we load data to target table

1447

---

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1860

---

what is Forward,Reverse and Re_engineering?

2268

---

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.

2120

---

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2133

---