Answer Posted / vamshi

Please forward to my mail id also.

chvamshy@gmail.com

Define slowly changing dimensions (SCD)?

1001

---

Explain about power designer data modeling software?

795

---

What is Data Vault???

2678

---

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1011

---

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

1743

---

What are cubes and olap cubes?

917

---

Explain about enterprise scalability and roi of data integration suite?

831

---

what is an ETL or ETT? And what are the different types?

7433

---

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

2056

---

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.

2152

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

920

---

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

1991

---

what is Forward,Reverse and Re_engineering?

2125

---

when will use SQL override in a lookup transformation?

2226

---

What is etl process?

871

---