SCD typeII implementation
Posted: Fri Jan 30, 2009 6:28 am
I need to Use SCD stage in data stage parallel 8. in my design, I have a source table which lookup dimension table based on primary key, and tgt table have startdate,end_date along with the Src table.
inside the SCD stage there are options to generate surrogate key using flat file option.I need to know whether this flatfile is created at runtime or do i need to create it manually before using the file. and if so how to create it?
there are some flat file created already,which is there in the repository(No idea how that was created), when i try to use that file,the SCD stage is not reading the particular flatfile. am getting the error as:
APT_CombinedOperatorController(0),0: Lookup table is empty, no further warnings will be issued.
APT_CombinedOperatorController(0),0: Unable to read state file /home/dsadm/dsinputfiles/s_key_src.csv: Invalid argument.
Unable to read state file /home/dsadm/dsinputfiles/s_key_src.csv: Invalid argument.
one more doubt: regarding state file in SCD stage...wat are statefiles and how they created...
inside the SCD stage there are options to generate surrogate key using flat file option.I need to know whether this flatfile is created at runtime or do i need to create it manually before using the file. and if so how to create it?
there are some flat file created already,which is there in the repository(No idea how that was created), when i try to use that file,the SCD stage is not reading the particular flatfile. am getting the error as:
APT_CombinedOperatorController(0),0: Lookup table is empty, no further warnings will be issued.
APT_CombinedOperatorController(0),0: Unable to read state file /home/dsadm/dsinputfiles/s_key_src.csv: Invalid argument.
Unable to read state file /home/dsadm/dsinputfiles/s_key_src.csv: Invalid argument.
one more doubt: regarding state file in SCD stage...wat are statefiles and how they created...