DSXchange

Senthil, if you want to lookup things there is no method to bypath a lookup. If words are written wrong even the best computer system cant find the join. There are ways to compare similar sounding words or manual correction before you join them. If you have to lookup line 4711 of file1 with line 471...

I dont know of any way to do looping like that in DataStage. And I imagine it would kill performance since you would on average loop through half the rows in the second file for each row in the first (but maybe the files arent too big?) Unless Ive misunderstood the problem, it still sounds to me lik...

Hi Eric; My problem is that I cant use hash lookup. Bcos the input from the first file is an incorrect,misspelled word and so i cant perform a lookup on the second file. I need to get the i/p from the first file and scan for each row in the second file and pass the data to a routine which does some ...

Hi there, My suggestion would be to dump the first file to a hash file and then for each row in the second file use hash lookup. Regards, Eric Mortensen -----Original Message----- From: Senthil Kumar B [mailto:Senthil_KumarB@mindtree.com] Sent: Fri 23.05.2003 08:28 To: datastage-users@oliver.com Cc:...

Hi: I have a doubt regarding loops in datastage. I need 2 inputs from 2 seq files into a transformer. Each row on the 1st seq file should be compared with all the rows in the 2nd seq file. How is the looping posible ? Senthil. DISCLAIMER: This message (including attachment if any) is confidential an...

Hi Jenny, What version are you using. In DS 6.0 you could use the new "link collector" stage to collect your records into a single stream. Either define two SEQ stage linking in or one SEQ stage with two output links. This new stage requires the metadata to be exactly the same for both input links. ...

When you schedule a datastage job using director an entry is added to the host scheduling mechanism, cron for unix or AT for windows. Therefore you can schedule the required the job using director and then change the timing in the operating system. If your server is windows then StartProgramsAccesso...

lourenco.arnasalon@itc.alstom.com wrote: > Hello everybody, > I need to execute a job every day and this every 15 minutes. > > Is there a means of scheduling it without having to select in the > director module every scheduled time (00:00, 00:15, 00:30, ....) with > a lapse of 15 minutes. > > Thanks...

Hi Dodu: Have a lookup file(hash) that will contain the distinct values of the id column. Take the input and do a lookup onto the hash file. If the lookup succeeds then concatenate the value in the existing set for that particular id in the hash file. If it fails then just insert the id in the looku...

Hi, >From that kind of text file : ID, VALUE ID1, "A" ID1, "Z" ID1, "E" ID1, "R" ID2, "T" ID2, "Y" ID2, "U" ... I would like to obtain : ID, VALUE ID1, "A,Z,E,R" ID2, "T,Y,U" ..... How can I do that with DS ? Does someone have an idea ? Im using the old DS 4.0.R.3 on NT. Etienne Dodu EMERSYS

Yes it can be done, but with difficulty. You will need some pretty good UniVerse skills because the file dictionaries (repository metadata) are deliberately left incomplete. Further, it does not use a first normal form structure (the repository uses seven tables, the normalized form used by the docu...

What about running the jobs with the "dsjob -run" command from the command line? I believe it will run as who you are logged in as. Then run the job under the windows scheduler with a specified user. -----Original Message----- From: Scott Brooks [mailto:sbrooks@psu.edu] Sent: Monday, May 19, 2003 6:...

Hi Sushma, you have a problem and you need a solution. Please tell the whole story of your problem and we can give you a solution. If your value is 30, do you want to be told, (a) that 30 is between 16 and 50 or (b) 30 is not between 5 and 15 Wolfgang > -----Original Message----- > From: Sushma KR [...

Hi All, I am new to datastage. Suppose the input contains a value 10 and the range specified in the hash file (i.e the lookup) is 5 to 15. Since 10 lies between 5 and 15, the result of lookup should yield me the boundary values 5 and 15. How can this be accomplished in datastage. Input File Lookup(H...

Hello,

Im new to the list.
Im looking for info about the Datastage repository, which is proprietary.

Is there any way to export some metadata from DStage (table definitions, job
names ...).
Any comment on this subject is hotly welcome !

Regards,
Ben