DSXchange

Hi Is it possible wherein we can change the job parameter based upon each of the input record. To be more specific i have scenario wherein i want to do join of input A with input B. For each record in the input A i need to fire specific query to fetch records for B, which i will then be use for joi...

If there is a table definition that is used in several jobs, I would like to change table definition (for example, column name) in one place and have all database stages that refers to it get default SQL changed. Also I would like to have name and password recorded in one place only so it a user id...

drorya wrote:
from dror

Never use illegal copy. Ascential is more aware of license issues. As apart of my job, I have to use different installation procedures as per client standards. That procedure violates license terms, so we took permission by e-mail. Don't make mistake in this.

I recall having had to use a 3rd party tool to access an ODBC data source on the Windows platform (SQL Server, Access, etc.) from a UNIX-based DataStage installation. Is this still the case, or is the access now done differently; in this case it is AIX accessing SQL-Server. Yes. you can use 3rd par...

PhilHibbs wrote:

kcbland wrote:...or even use the hack job I wrote at my website.

Where would I find this "hack job"?

You better consider parameter manager tool. As per Ascential, there is no plan to provide in next few releases that kind of functionality. Proabably you will have ROI.

Suparv wrote:Hi

Could anyone tell me if there is a way to call QS jobs using the "dsjobs" command??

Thanks

You can run the job from command prompt by using jobname.extensions script. QS compilation generates scripts with different extensions to run in different modes.

Is there a way of copying a load of parameters from one job to another? Personally, I would export the jobs as XML and copy and paste the appropriate sections, but my colleague is not entirely confident with that approach. If you know how Datastage writes DSX files, you can copy and paste relavent ...

u r correct sree.my previous developer design a job which loads in to fact table using a wrong hash file.The job is running for couple of months and now the fact table has 46 mil records of wrong data.for the last one month i am working on it.now we are updating the entire fact table. i think each ...

Hi, I have developed a sequence and a set of DS PX jobs. I need to write the test cases for them. Can I have a list of indicative test cases that can be run on the sequence and the jobs? Cheers, Mohan You have to write and test all test cases to cover atleast the following creteria: a) all input co...

I am shopping for a tool for some Data Migration work and I'd like to ask if anybody out there have any idea if DS can create via a transformation job an XML file from an input of a text file. My target system will only accept as Input an XML file format. Can any of the assential tool do this for m...

Hi,
Instead of requesting Database to provide maximum number of the key column and then using lookup, we better to use "sequence" object to provide the next value for table population in performance point-of-view.

Sree

7.1 is the release version(they print on installation CDs and in discussions) is same as 7.0.1.1r2. When you request server using the command "uv -admin -info" you will see " 7.0.1.1r2" as version name( Actual build name given by Ascential release system). I am also using the sam...

ray.wurlod suggestion is good. It not only works for the files with dates but also for your client/project file/parameter naming standards. By creating one routine, all team members can use. I use the same.

Before all, you need to make a decision where you want to store your data( what DB and which OS). You need to choose appropriate products like DS390 and/or parallel extender(depends on servers and load size). look into accelerators and DSL used in ETI and the most important how you want to mange you...

For example, if you want to process data from different geographical areas (time zones) due to volume of data and provide data to users in those areas as soon as you finish. In that case you need to process data using same methodology with different parameters. You can use multiple instances of the ...