Answer Posted / sowmi

scd 1:It wont implement the new change.It always contains
the historic data alone.
scd 2:It will replace or overwrite the existing record.It
will not contain the historic data.But it has surrogate key.
scd 3:It contains both the old data and a new record with
the modified information and has additional columns like
"effective start date and end date" or "version no".

Please correct me if i am wrong

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

1028

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2168

---

how to write server Routine coding?

2060

---

Explain the situation where you have applied SCD in your project?

1972

---

Define project in datastage?

1050

---

What are the stages in datastage?

1027

---

Differentiate between odbc and drs stage?

997

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1170

---

What are orabulk and bcp stages?

1067

---

How to read the length of word in unix?

1310

---

What all the types of jobs you developed?

1115

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4136

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3129

---

How many types of views are there in a datastage director?

1231

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1069

---