DataStage - SCD2 Parallel Jobs

GeekInterview.com > Tech FAQs > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 136 of 140

SCD2 Parallel Jobs

How to implement SCD2 in parallel jobs?

Total Answers and Comments: 1

Last Update: September 23, 2009 Asked by: mast.shar

Sponsored Links

Best Rated Answer

—

Submitted by: veer.dwh

If you are using DS 8.0.1 version, it is very east to implement SCD2 using SCD stage. it supports 2 input links and 2 output links. from the 2 input links. primary Dataset it takes as a current dateset(which has updated information) and 2nd dataset set it will take as refernce table or dementional dateset(which has old data).

Compares these 2 datasets and generate surrogatekey and effective timestamp to store historical date in target. that is taeget. the other o/p link stores updated information(which rows has updated) from the dimentional dataset.

If you are using DS 7.5 version, you have to use change capture stage to denote differnce b/w primary data set and dimentional data set. then you have to use surrogate key stage to pass surrogate key in target table to store the updated information in target.

Thanks,
Veeru.

Above answer was rated as good by the following members:
Abhijain

September 23, 2009 06:34:37

veer.dwh

Member Since: July 2009 Contribution: 29

RE: SCD2 Parallel Jobs

If you are using DS 8.0.1 version it is very east to implement SCD2 using SCD stage. it supports 2 input links and 2 output links. from the 2 input links. primary Dataset it takes as a current dateset(which has updated information) and 2nd dataset set it will take as refernce table or dementional dateset(which has old data).

Compares these 2 datasets and generate surrogatekey and effective timestamp to store historical date in target. that is taeget. the other o/p link stores updated information(which rows has updated) from the dimentional dataset.

If you are using DS 7.5 version you have to use change capture stage to denote differnce b/w primary data set and dimentional data set. then you have to use surrogate key stage to pass surrogate key in target table to store the updated information in target.

Thanks
Veeru.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Advertising Industry Jobs

Advertising Industry Jobs for IT Professionals : Today there are many global enterprises which are integrating both technology and entertainment. Many of these firms develop and market services and products which have the ability to greatly enhance entertainment for many consumers. These companies w

Finding Your First Job Researching Jobs

by ResumeEdge.com - The Premier Resume Writing and Editing Service Now that determined your interests and skills, time to do some heavy-duty research on occupations. Now that determined your interests and skills, time to do some heavy-duty research. lose sight of the fact that your ability t

Does New College Graduate Equal Entry Level Jobs?

Does New College Graduate Equal Entry Level Jobs Breaking into the career field of your choice after college can be more difficult than some people may imagine During college all you can think about is the education and getting through the process of receiving that education and when you graduate yo

Applying For The Jobs That You Deserve

Applying For The Jobs That You Deserve So you’ ve finally graduated from college and it’ s time to find a job This is a scary and exciting time and it can be a bit hard to determine what jobs you should be applying for Many college graduates actually make the mistake of applying

After Graduation: Where To Look For Jobs

After Graduation Where To Look For Jobs Searching for a job can be very stressful for many students nearing graduation Unfortunately all the education in the world doesn’ t teach you how to go out and find the jobs you need and want after college so you need to know where to look to land t

Live DataStage Interview Questions

Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated questions here Live DataStage Interview Questions Published by Manoj G on 05 24 2005 Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated que

Finding Your First Job - Researching Jobs

Now that you ve determined your interests and skills it s time to do some heavy duty research on occupations mosgoogle mosgoogle by ResumeEdge com Now that you ve determined your interests and skills it s time to do some heavy duty research Don t lose sight of the fact that your ability to do effic

How to Search Jobs

With so many people now losing their jobs these days because of the recession searching for a job may not be easy as you have to compete with many others who may be in the same predicament as you are. It is quite prudent therefore for you to follow some time-tested and quick time-saving job search t

Creating Jobs for Silverlight SMS Distribution

Once you have generated the SMS package which is necessary for Silverlight you will next need to distribute it through the creation of a job. There are a number of things that this job may include and one is the collection of computers that will get the SMS package which is needed for Silverlight. m

SOA Web Services - Parallel Process Application Pattern

Parallel Process Application Pattern This is an extension of the Serial Process application pattern where the sub-processes are executed concurrently on multiple targets. This is illustrated in the following figure. mosgoogle The concurrent execution of sub-processes requires a more sophisticated e

User Name		Remember Me?
Password

Question Bank