DSXchange

Hi Chullet, I too have the same doubt abiout the difference between Oracle OCI and DRS Stages.Apart from this I doubt whether Oracle OCI use native drivers.Please let me know whether any performance difference between Oracle OCI and DRS Stages in DS server 7.X and the database used is Oracle. Both u...

Thank You ..CHullet.
The workaround provided has resolved the issue.

HI CHullet, There are two lookup columns[PERSON_ID(KEY,CHAR,15) & SRC_SYS_ID(KEY,CHAR,5)] which have to match with two source columns[EMPLID(CHAR,11) & SRC_SYS_ID(KEY,CHAR,5)].After the existence of values which are same in lookup and source,We need to populate another column[PERSON_SID(INTE...

I was trying to post images but failed to do so.

Hi Chullet, I am very sure I have been checking the data in hash file job,In which the data is loaded into hash file from DRS.I've LTRIM &RTRIM in source ODBC stage and also checked in hsh file after loading.I have checked the source data in the main JOB alsono spaces before or after the field v...

Dear ArndW, I had debugged my JOb and found that the key exists the Hash job also. Dear chulett, I am very sure I have Ltrimmed and Rtrimmed before loading them into hash files. Dear JRodriguez, -Have confirmed again that the hashed file names are same in both the jobs -Also key definition is same. ...

Dear All, I have a job in which,there are source DRS,3 transformer Stages,Target DRS stage.Also there are lookup stages for all of the transformer stages. Now,For my second transformer stage,there is a lookup apart from other 5 lookups.The data comes from alll the lookup stages except from that sing...

ray.wurlod wrote:DataStage does not control this. If the name of your target table is actually the name of a view, then it's a view you have. Chat with your DBA. If DataStage is generating DDL, it's always CREATE T ...

Thanks Ray.I got it now.

That is not what was asked, you can read a view from one database and write to a table or updateable view in another database. ... Thank you.Yes this is another Question :) Anyway when i was trying to load data from a view I am getting target also as a view.May I know what could be the issue please.

But can we convert a view data of a database into a table of another database.Is there any chance.

Thank you for the responce.
Hvae a nice day

Hi Friends,
Can we transform a view(NOT Table) from source database to target.Is there any way or chance to do so.Please help me.

Dear Friends,
Could any body help me regarding this.I have a requirement like i have to update a table directly from a routine.My routine gives a value which should be updated in a table directly.

Dear Friends,
I have a database issue.During my total load i have to access source database in which it is throwing the warning "the DB password expires in 3 days".This is affecting the load(the run fails!!).Can we overcome this warning while interacting with the database.