Answer Posted / srinu

materialized views are used in lookup stage,for data refernces in local machine.these does not import physical data into local machine just refernces by using materialized views

What are the different common services in datastage?

1276

---

What are the main features of datastage?

1279

---

Define data aggregation?

1091

---

Explain the importance of surrogate key in data warehousing?

1185

---

Can you implement SCD2 using join, transformer and funnel stage?

1549

---

Distinguish between informatica & datastage. Which one would you choose and why?

1004

---

How will you move hashed file from one location to another location?

2149

---

Describe the architecture of datastage?

1001

---

Define project in datastage?

1089

---

Explain datastage architecture?

1397

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2079

---

Can you explain players in datastage?

1186

---

Is it possible to query a hash file?

2004

---

How do y read Sequential file from job control?

15950

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2043

---