Answer Posted / satyam

yes ,the above one is correct But datastage8.0.1
onwards
client component has
datastage designer(manager+designer),
datastage adminstrator
datastage director
server component has
datastage server
repository
datastage package installer

Why fact table is in normal form?

1260

---

What are the different type of jobs in datastage?

1045

---

What are the areas of application?

1152

---

what is the use of materialized view?

1575

---

What are the functionalities of link collector?

1085

---

How do you import and export the datastage jobs?

1163

---

What is the sortmerge collector?

1133

---

How to perform incremental load in datastage?

1208

---

What is the purpose of pivot stage and types of containers in datastage

1042

---

What are stage variables and constants?

1151

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1088

---

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

2088

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2115

---

Why we use surrogate key?

1239

---

Which algorithm you used for your hashfile?

1187

---