DataStage - How to develop the SCD using LOOKUP stage?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 337 of 380

How to develop the SCD using LOOKUP stage?

Total Answers and Comments: 3

Last Update: March 07, 2008 Asked by: vijay

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 25, 2008 05:27:10

manoharkolukula

Member Since: January 2008 Contribution: 32

RE: How to develop the SCD using LOOKUP stage?

we can impliment SCD by using LOOKUP stage, but it is for only scd1, not for scd2.

we have to take source(file or db) and dataset as a ref link(for look up) and then LOOKUP stage, in this we have to compare the source with dataset and we have to give condition as continue, continue there. after that in t/r we have to give the conditon, after that we have to take two targets for insert and update, there we have to manually write the sql insert and update statements.

If u see the design, then u can easily understand that.

Is this answer useful? Yes | No

March 07, 2008 05:33:07

ramasamba

Member Since: November 2007 Contribution: 6

RE: How to develop the SCD using LOOKUP stage?

every one saying meaning of scd2, any one can explain practically and technically

Is this answer useful? Yes | No

March 07, 2008 05:38:15

ramasamba

Member Since: November 2007 Contribution: 6

RE: How to develop the SCD using LOOKUP stage?

can u explain with example(SCD2), i think this can solve real time guy but not meaning and definition. can any one take example and explain clearly.

Is this answer useful? Yes | No

Go To Top