Answer / pranay

scd2: slowly changing dimension 2

SCD2 is used to maintain both current data and historical
data.
for ex: If we are having following data
cid cname city country
101 raju hyderabad India

if we want to implement scd2 for the above data we need to
create target table with columns

scid cname city country flag version date
scid - surrogate key column

and if the customer moves from hyderabad to delhi then the
output will be

scid cname city country flag version
1 raju hyderabad India 0 1
2 raju delhi India 1 2

Flag = 0 defines historical data
Flag = 1 defines current data

Similarly if again raju moves from delhi to mumbai the the
output will be

scid cname city country flag version
1 raju hyderabad India 0 1
2 raju delhi India 0 2
2 raju mumbai India 1 3
n so on..

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

What is APT_DUMP_SCORE?

2 Answers   IBM,

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

Explain ibm infosphere information server and highlight its main features?

0 Answers  

---

---

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,

---

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,

---