DSXchange

Thanks for the quick response!!! But I don't totally agree with this. This is bringing close coupling between the datastage metadata & the database. We're defining the keys in the Datastage's metadata so doesn't that suffice; just curious to know. Additionally unique constraint check on the DB c...

Hi All, We need to Upsert (Update else Insert) into a table. We're not planning to use CDC. Now target OCI verifies against the database for a unique key/index constraint for upsert. But we might not have indexes/unique constraint defined in the Database. Any fix for this. Just to sight this is poss...

We're reading through Oracle database. We tried that, it doesn't work. It is converting into some Chinese language characters but not the actual ones...

select * from DS_JOBS doesn't show me Project Name (while firing this query through DS Administrator>Command as it fires command for a particular project)... Also if we use Universe Stage then will datasource name=localuv give me the right DB for query

We're sourcing information from a database which stores data in UTF8, but the encoding (that happens through Web) is in Japanese (Shift+JIS). Now, we've to decode Shift+JIS & encode into UTF8 using DataStage. As per our understanding a character say 00FF in Shift+JIS will stand for X whereas the...

We've to check whether one job is in running status or finished status (but that job is not in current project) How to check the status of a job across projects?

Of course I don't see any. I can't see your data. Try UTF-8; chances are that that's the best fit for the Oracle map. Is this what's specified in the oracle_cs.txt file? ... Thanks for your prompt response! The problem that i see is, the source is Oracle in AL32UTF8 (Unicode 4.0)--> DataStage in UT...

Welcome aboard. The "preferred" character map is the one that is used to encode your data. So, if your data are encoded using UTF-8, then use that. If your Chinese data are encoded using BIG-5 or ... Thanks for the response. We're extracting information from Oracle (NLS_CHARACTERSET=AL32U...

If I've few jobs that need to handle multiple language (rest just English) , then do you suggest setting NLS =UTF8 for project level or at job level. Also, is UTF8 preferred for English?