DSXchange

ntr · Post by **ntr** » Wed Aug 29, 2012 2:06 am

Hi,

i am not able to get the data from one input link of SCD stage .actually
that input dataset containing data but it is processing zero records

into SCD stage and also giving me a warning in directory "Lookup

table is empty".

can please help me

Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Aug 29, 2012 5:35 am

Make sure that your lookup table (dimension table) is not empty.

ntr · Post by **ntr** » Wed Aug 29, 2012 5:43 am

Thanks for the reply ray

i had extracted the data into dataset from dimension table and used

that one in my job . iam able to see the data in the dataset but its not

processing data into SCD stage

ntr · Post by **ntr** » Thu Aug 30, 2012 1:02 am

Can any body please

Thanks

SURA · Post by **SURA** » Thu Aug 30, 2012 1:25 am

Share what you did in SCD (Fast Path 1 to 5)

ntr · Post by **ntr** » Thu Aug 30, 2012 1:52 am

Thanks SURA for reply

In first step i had given output linkname

in second step i added purpuse code for all columns and did lookup with

BUSSINESS key column

in third step i had given surrogate key file which was created by

surrogate key stage

in fourth step mapped the columns into derivation and

startdate as currentdate and enddate as string in derivation and

currentdate in expiration ,nextsurrogate key in surrogate key collumn

5th step mapping

Thanks