DSXchange

The bussiness want to maintain the multiple records(Realtime) for each employee working on different locations and SSN in the lookup and insert a single active record in the target table. So that when the same employee come in with the same SSN and same ID and diff location it will do the updates an...

Runtime Column Propagation is valid ONLY AFTER YOUR INITIAL TABLE STRUCTURE IS DEFINED. that means the table needs to exist on the target database and in case of any additional columns that need to be added can be done using RCP..same with server also you can use a RTI I map creation specifics to do...

I am using DB2 udb stage as lookup stage and inputstage

I am applying type II for this Job design:
When I am loading initially it will run successfully without any warnings.
when I run with the diff month of data with update and inserts i am getting the above error.

IndividualDim_S..X_individual: Reference lookup generated 3 rows. Only the last row was used.
When data exceeds above the recordcount then I am getting this warning.

Admin will have all rights use those tabs.

you can schedule your jobs from director :
Go to director ---> Tools--->Add to schedule

Ok well, are you able to load data into the FF successfully.

Delimited Substrings is the one You can extract using this syntax: string [ delimiter, instance, fields ] string is the string containing the substring. delimiter specifies the character that delimits the substring. instance specifies the instance of delimiter where the extraction is to start. field...

Delimited Substrings is the one You can extract using this syntax: string [ delimiter, instance, fields ] string is the string containing the substring. delimiter specifies the character that delimits the substring. instance specifies the instance of delimiter where the extraction is to start. field...

Is there something in Datastage that can copy objects(Tables) from one database to another. If there is change in the table (example , addition of a column) in the source database , there should not be any change in the Datastage job as the whole table gets copied.

Why donot you delete the input stage and again import the metadata and see, if it works
validate the data may be in char field its passing some numeric values.......

May be you have to check column by column and see if you have any sqltype or length not matching to any column on the target DB.

Sorry I replied to the diff topic

which one did you specified the hashed file by account name or directory
path ??

Shilpa.

No, I havenot taken any classes.