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 are iconv and oconv?

1246

---

How you can fix the truncated data error in datastage?

1794

---

What is the process of killing a job in datastage?

1021

---

What is ibm datastage flow designer?

1152

---

Explain how a source file is populated?

1370

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2232

---

how to sort two columns in single job in datastage.

2906

---

EXPLAIN SCD

1410

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

---

How to RD using transformer?

1429

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2224

---

Can we use target hash file as a lookup ?

3327

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

---

Name the different types of Lookups in Datastage?

1263

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2814

---