DSXchange

Hi Which is the best way to achieve this in a hash file Input: COL1,COL2,COL3,COL4,COL5 A,B,C,D,1 A,B,C,D,2 A,B,C,D,3 E,F,G,H,10 E,F,G,H,20 E,F,G,H,30 OutPut: Last column separated by any delimiter ex:char(250) A,B,C,D,1|2|3 E,F,G,H,10|20|30 The key columns in my source are col3 and col4. I created ...

Kim, Thanks for all the help. I was able to get all the source code what I want in html format. You added an excellent feature of getting the report for all jobs or by category. I noticed that you changed the JobReport input parameters. The orginal JobReport takes three parameter and third one has m...

Hi All, Is there a way to copy all the user source code to a file? For example, there is a datastage job, with database as source using user defined sql and flat file as output. I want to extract all SQL from the source stage and any transformation logic in the transformer. Is this possible? Is it p...

The target is a flat file which is an input file to another datastage job for some transformations.

thanks

I ran the extract job checking the "allow multiple instance" in the job properties in our devlopment,where we have around 4 million records. I compared the timings with the previous run, this job took 2 min more than the previous one. Is there any other way of running the job in multiple i...

Thanks for the quick responses. I have 110 columns in the table and the where clause what I have is
((COLUMN4 >= '200211') or (COLUMN4 is NULL)).

If I run the job in multiple instances will it improve the speed or do you think I have to add anything else on the where clause.

thanks

Hello All, I have a select query with a simple where clause which retrives 40 million rows out of 88 million. In DataStage I am using ORACLE9i stage to extract the data into a flat file. This job takes 5 hours to complete. Is there anything should be taken care of for the faster retrieval. I heard t...

Hi All, Does the row splitter splits the rows into columns based on the delimeter? If not how do we split a single string without any delimiter into two columns using this stage. I tried like this in the input I have Id char(12) and in the output I defined as two columns with char(6) each but it doe...

Is it possible to do it DataStage either by using hash lookups or some other way to solve this kind of problem. My input is TD Stage.

thanks
rcil

I am doing an extract job in datastage which extracts data from a database and loads it into a flat file, the logic invovled on two of the new columns on the target is select p.s1,p.s2 from product p,item t where p.s3=t.t1 and t.date1>='2000-10-10' if rowsReturned= 1 then s1,s2 if rowsReturned>1 the...

Thanks for your response Ray. Yes you are correct, I want my target sequential file to be saved as a Timestamp.extension(ex: txt,dat etc). According to your first solution do I have to use the mv 'date' in after job routine? Please can you be more specific to your second solution? and on what do I h...

Hi

Is there anyway that I can save my target seq file as TimeStamp.

thanks
rcil

Thanks Ray that helped.

rcil

Is there a different approach to solve the above problem???? Hope there should be one to solve these kind of situations.

thanks,
rcil

Thanks again Craig. I really appreciate your help.Yes, you are true that I am using the lookup only to find out the OriginalEntry date for that record but that date is not in my input database becuase of the DateEnter filter which is >=03/20/2002 but in the originalEntry column I need the date older...