DSXchange

hi , i havent used a routine anytime but i used the keymgmt function.can you please explain how to use because i used that function as keymgmt(constant value) in my transformer and i used it .other than that i dont have any idea of how to use in any other way.can you please tell me in detail of how ...

Hi craig , can u please explain me how to capture the MAX() value outside the job and pass it to increment the job parameter for each record.so you mean to say i have to get the max value through aggregator only and i have to use a different job to get a maximum value and then use that value in the ...

hi , can you tell me how to implement it through a job parameter oor through a reference link.i am new to the datastage and i had taken a stage variable and used it i.e. stagevar=MAXIMUM(inputlink.surrogate id)+1. It didn't work.i think my function is wrong.i dont have any idea of how to find it thr...

Hi everyone , my source is a database which will be loaded into oracle tables. Suppose for example, if I get 10 records today, I need to assign a Surrogate Key only to these records which are new records and i have to use the same surrogate key for the updated records and load it into the oracle tab...

Hi everyone , i am trying to implement scd2with Sk. database---->transformer---->target database(update) ^ \ | \ | target database(insert) target database while i am executing , the job is abortING.I AM GETTING AN ERROR AS scd2san..xfm1: |scd2san..ODBC_15.update: DSD.BCIOpenW call to SQLPrepare fail...

Hi ,

I tried to solve the problem but i have a small problem as in my input i had given as 2099-12-12 08:45:54 but in my output i am getting as 1973-09-05 08:45:54.Can anyone tell me why am i not getting the same date as given in the input.

thanks in advance

Hi ,

I haven't done anything with parameter8, but i am trying to fix it for parameter7 only.so please can you tell me now what is the error in parameter7.Does my function is wrong or anything else.So what is the solution to fix in parameter7.

thanks in advance

Hi everyone, Even though if i use to_timestamp() , still i am getting the same error: insert..Transformer_8.DSLink9: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO "sanexis"("sid", STOREID, NAME, CITY, STATE, CID, STARTDATE, ENDDATE) VALUES (?,?,?,?,?,?,TO_TIMEST...

What is the data type of your target table column? DATE? Unless you precisely match the NLS_DATE_FORMAT of your target, you need to use TO_DATE() in your SQL with a mask that matches your incom ... Hi , my target datatype is 'timestamp' and can you please tell me how to match the NLS_DATE_FORMAT.i ...

hi , i have a date field with datatype as 'timestamp' , need to upload it to oracle using odbc stage. i got the following error 'insert..Transformer_5.DSLink5: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO"sanexis"("sid", STOREID, NAME, CITY, STATE, CID, STARTDA...

I have given two full directory paths for the first and second file and file names for the first and second.i have give the metadata for both the files but i see in the merge stage ,'view data' option is not enabled.I dont knw why is that not enabled.Please can you tell me should the 'view data' opt...

Hi , i tried to land the source to a flat file by giving a specified path and then used merge with the path which i had given for the flat files. i also tried taking dummy data in a new files and tried to do the unit testing but getting the same error.please can you tell me is my approach wrong or a...

hi ,

i did the same way as u told but i am getting the following error:
Merge..Merge_0: Link property retrieval error

please can you tell me what is this error for and how to rectify this error.

thanks in advance

Hi everyone , i tried to do complete set using merge but i am getting the following error. Merge..Merge_0: Link property retrieval error i want to know we can merge only for the flat files as my source are database and i couldn't able to perform merge as there is option available only for flat files...

thanks everyone for the reply, but please can any one tell me how to find a solution for this as my source dont have start and end date and my reference has both startdate and enddate.now i am trying to implement scd type2 and i tried to implement the logic but not working as i am finding the same e...