DSXchange

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

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

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

Can any body please


Thanks

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

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