DSXchange

Hi, i have a requriement where i need to lists all the job in a project. For this i have used DSGetProjectInfo(DSJ.JOBLIST) function in the transformer and capturing the output in one column in a comma delimated sequential file. I am getting outpur like this column1 ========= A,B,C,D,E,F etc But i n...

Ok. Tell us what is the datatype for this field in both source and target including the lengths and nullable/not nullable? For testing purpose try replacing the target stage with sequential file and check what happens. Aslam, Thanks for response Both source and target fields ar varchar. Source fiel...

Ok. Tell us what is the datatype for this field in both source and target including the lengths and nullable/not nullable? For testing purpose try replacing the target stage with sequential file and check what happens. Aslam, Thanks for response Both source and target fields ar varchar. Source fiel...

Rafi, It seems you are doing some transformations on the ACCESS_CODE and ELC_ACC_CDE columns and the data in those field are either not in proper format or having some wierd data which your target stage is not recognising. what transformations are you doing? Aslam, Thanks for response! In transform...

Hi DSguru2B and Ray, Thanks for reply. I have reset and ran many times, same issue i am getting. There is no error, only warning message. The log also shows correct rows, As per log it shows 168667 rows loaded into target table, but while checking using select count statement, it shows 168615 rows. ...

I am selecting distinct rows from the source itself.
and there is no warning regarding unique constraint the logs

Hi, My source is db2 udb and target is alos db2 udb My job extracts data using db2 udb api stage and loads using odbc stage into the target. This jobs also captures rejected and filtered rows using constrains writeen in the transformer. The issue is while loading into the target some of the rows are...

Thanks a lot DS_SUPPORT

yes it is wokring.

Thanks u again!!!!!!!!

Hi Gurus, i was just exporting one ds job from ds manager, suddendly some error occurred. when closed error windows after that all my jobs in that project disappread. though i am unable to export the job but can't see any job. i restarted ds sever, even though it is not displaying any job. Plz give ...

Hi All, in my job i am using db2 udb load stage, while loaing data into target it is giving the following error though i set database_name,user_name,password,table_name and other properties correctly. here database_name is dsn name. when i use odbc stage, it is working fine. but for db2 udb load sta...

Hi vmcburney, but thing is that they want to implement EDM in staging area after transformation , just a replica of the target. Does it help us for target environment. my suggestion is instead of in the staging area, there will be EDM only for target. correct me if i am wrong. --rafiq

Hi All, i am handling one data migration project. In the source there 54 database having around 900+ tables. now clients wants to migrate data (around 500+ table) in the target(db2) after transformation and apply business rule. For this they r planning to have one EDM in staging area. also they plan...

Thanks Arnd and Rich,
The problem has been resolved after changing the link order.
Now my problem is how to maintain the version number of each record in the target as i mentioned in the last message.
source as well as target are text files

any solution?

Thanks in advance

Rafiq

Hi Rich, thanks for ur quick response As per your solution i went thrugh it. But whenever there is any insertion or updation in the source file(text file), the conditions in the transformer become false. when i give condition like change_code=2 then it become false? which is i suppose for deletetion...

Hi all, i want to implement SCD 2 in parallel job. i have tried using change capture and change apply stage, but using these stage i am not able to maintain version control. my requirement is that if 1) new record in the source -> then insert it into target with new row id 2) changed record in the s...