DSXchange

What are the environment Oracle variables you are referring here?

What are the environment Oracle variables you are referring here?

I will have to create a simple job which reads from a delimited file and load in oracle (using OCI stage).Only thing is that data is in Chinese language.Oracle DB character set is UTF8.What configuration do I have to do at datastage level?One I can think of is to set up NLS as UTF8 at job level.Requ...

Ok.But in which case we should go for hash file deletion and recreation approach ? Is it like when the daily volume from the source table varies a lot? But then is not type 30 hash file dynamic?Will it not adjust when the volume is more ?So what's the point in deleting the old copy rarther than simp...

We have a number of lookup tables which we need to refer in various jobs.So before starting main processing we run a job to unload the lookup tables and create hash files(type 30) which will be looked up in subsequent jobs.Now my question is whether we should configure the hash file so that the old ...

ok....from which version is it available?...is it there in server(7.5x)?

Yes,databases may differ but in most of the cases it is Oracle.ODBC stage should be ok.I have started a POC.Let's see how it goes.I don't see much of a problem regarding parameterization (DB login,source query) but my main concern/doubt is whether to go ahead with multiple instance job.As for DRS st...

Thanks for your inputs,guys...and yes Ray, only if they would have been a little less "intelligent' !

I know..I have that option in mind too. Currently there are 2 source systems for this target and a new one is being integrated.Now the management wants to build a new "generic" interface for integrating the new source(3rd one,first 2 will be kept untouched) and hereafter any source being i...

Initially my idea was also of using project level parameters.But now I need to build a generic etl job where target table structure is fixed (a particular oracle table) but source structure varies(different oracle db,MS Sql Server etc..structure is also different). My idea now is to create only one ...

I need to run 14 jobs in parallel . Now I would like to know what are the factors I need to consider before deciding how many Job Activity I can run in parallel so that there is no major performance impact or execution problem?

Thanks for the tips....another question which is related to this...I am also parameterizing source db credentials(job parameters) and storing the value in a table.This is since different jobs may fetch same data from different schema.Now the question is how to encrypt the pwd?Had it been at the admi...

I am thinking of keeping a control table to store various ds param name/value pairs.Can store the source query there only.But could you please explain a little about the "issue with quotes being stripped of ..." that you mentioned ?

Is it possible to parameterize the whole sql query used in a source oci stage?I would like to have a table to store the queries,use a parameter like "source_query" in oci stage and pass the value dynamically in job activity stage. Need some suggestion on what's the best way to do it.

If I need to read various non english language data in a job,what are the settings do I have to worry about?As per my understanding I need to set proper NLS at the job level (compliant with source and target db character set).Is there anything else that I need to check out? Do I need to check the NL...