DSXchange

Create a job which loads dimension keys into Fact table. Run this jobs using job sequencer. Depending upon the requirement u can run this job in parallelism or sequentially. You may also use Parallel Extender to assign keys. Please read DS documentation: Parallel Job Developer Guide Some Good practi...

Hi
When i tried connecting to DS Server i get the following error

Failed to connect to host: <ip address >, project: <xyz>(The connection is broken (81002))

Thanks
Pramod

Hi
Does Datastage have any Data mining tool?
Is there any free dataminig tool available?
Regards
pramod

Pramod

Hi Ray One fine day,when i tried to export jobs from my folder using Manager i got the following error.But I could import individual job and append to the file. Error Log : Error calling subroutine: *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project king_ces_dev (Subrou...

Hi ManjulaMadhu

F1,F2....Fn are the fields . dont relate the field to the ouput file.

Is there any solution other than custom SQL.

Regards
D.Pramod


Pramod

Hello The files header got trimmed in my previous post.Sorry!! refer to the my previous post for Field specifications. Input file F1 == a b Lookup File F1 F2 F3 ========= K1 a Des1 K2 a Des2 K3 a Des3 K4 b Des4 K5 c Des5 K6 c Des6 output file F1 F2 F3 ========= K1 a Des1 K2 a Des2 K3 a Des3 K4 b Des...

Hello Is there any tool in DataStage6.0 to get cartesian product ? for Input file F1 is a non-key column.(None of the other fields in Input file could be related to the fields in Lookup File) For lookup file F1 is the key. Input file Lookup File output file shuld contain F1 F1 F2 F3 F1 F2 F3 == ====...

Hi all
I am using Datastage6.0 I have two files which has same structure.I need to merge these files(i.e Combine the contents of 2 files)
Regards

Pramod

Hello I have a parameter file which contains userId,Password, Base directory path. I dont want to hardcode some parameters and path in my JOB. I have have sequencer designed for my job. Can i read the parameter file and pass those parameter to the job sequencer,which in turn pass these parameters to...

Hello 1234 are not parameters!! I would like to reframe my question. JOB1-JOB2-JOB3-JOB4 are independent jobs!! I want to control the sequence of execution of the above independent jobs. E.g: JOB1-JOB2-JOB4 JOB1-JOB4 User can select any of the above 4 jobs and can execute in which ever way he wants!...

I am using DataStage 6.0


Pramod

Hello I have a list of job designed. I want to have some option mechanism to run these jobs. Say for example, i have the 5 independent jobs 1 - 2 - 3- 4 - 5 Normally it will execute from 1-5. In some special case, I want my jobs to execute with option i.e. job1245 will execute the 1-2-4-5 in sequenc...

Hello
If i install Datastage server say on 8 CPU unit Machine.
But i want Datastage to use only 4 processors ?
Is it Possible?
Is there any feature in datastage which can restrict the Hardware utilization ?

Regards
pramod

Pramod

Hello I was reading through Parallel JobDeveloper Guide. I have few questions. 1. If I design for a multiprocessor architecture say (Partition parallel processing) for 4 CPU Units.Then I upgrade my system to 8 CPU unit system, but i failed to update my Configuration File!!! will the JOB use 4 proces...

I need to do arithmetic operation using date in(mm/dd/yyyy).
i need to find difference between current system Date and date present in some filed