Answer Posted / m.s

# 24 Please forward to my mail id also.

mskohli6@gmail.com

What is virtual Data Warehousing?

547

---

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?

1550

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1128

---

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

1712

---

what are the production issues in datastage?

9735

---

---

Explain do we need an etl tool? When do we go for the tools in the market?

615

---

What are materialized views & where do we use them?

486

---

How many steps etl contains explain with example?

473

---

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.

1625

---

What are the different etl testing categories as per their function?

531

---

Explain about power designer data modeling software?

459

---

What are the ETL Testing Operations?

615

---

how many steps are there in etl process?

535

---

how many maximum session supports to multiload in teradata ??

1692

---

What is full load & incremental or refresh load?

681

---