DSXchange

Hello All, Apologies if this topic is covered earlier. I searched for the answers before posting but didn't find any. I want to know how we delete the records from the table using datastage job. I mean I have a table I want to delete some data based on some of the filter conditions. Source and targe...

Ray,

Thank you for all the help. Your answers saved me many times. I am just curious how I see your 10000th post?

Thanks,
rcil

ArndW wrote:If you have a UNIX system you can never guarantee equal usage. I don't know how you differentiate or define your "EDW" and "DWH" - are they different DataSTage projects?

Thank you for the inputs. Yes, the EDW and DWH are two different projects.

thanks,
rcil

Hello All,

We have a 8 CPU production machine where EDW and DWH jobs will run. Can I know how we do a load balance so that both the environments EDW and DWH share the same amount of CPU usage?

Any ideas will be appreciated.

Thanks

All the inputs are greatly appreciated. My special thanks to Srividay as his/her routine solved my problem.

This is the great place to get help.

thanks

Hello All, I need some help in fixing the routine. The purpose of this routine is to know the job status, jobinfo, starttime endtime and linkcounts. I am calling the after job routine in the same job. The code is as follows $INCLUDE DSINCLUDE JOBCONTROL.H JobVar=trim(field(InputArg,",",1))...

Hello All, Can I know how to calculate the age by susbstracting two dates. For example (2004-12-01) - (2000-12-01) should give me the result as 4 years and I also want to round of the number if I get any decimals. For example if the result is 5.75 I want to take it as 5 and if the result is less tha...

Hello All,

Does everyone agree that, a hash lookup without any constraint is like left outer join and with the constraint as Not(refLink.NOTFOUND)is a equi join?

Your comments are appreciated

-rcil

Hello All, If I have 6 hash file lookups to be performed on a job then how good is it use 6 transformers for each lookup and how good is to use one transformer for all the lookup? Which is the good way of doing and what is the difference? I usually use one trasformer for all the 6 hash lookup but on...

Raj,

You can use a UNIX cat command to concatinate all the 5 files into one by executing the command using ExecSh in before or after routine based on your requirement.

Hope that helps.

Thanks for all the help. The problem I have is I am not able to read my source file through datastage. The file is in the format below with carriage return (^M) at the end of each line and all the rows are not with the same number of columns 123;abc;42001;10.00;56789;;;;^M 128;bdc;32111;12.00;^M 890...

Hello All, I need help in reading the input flat file which is in the format below 123;000456;32.11;89765;;;;; I like to write it to two different files one taking out the extra semicolon and the second populating 0 to those extra columns Result: 1) 123;000456;32.11;89765 2)123;000456;32.11;89765;0;...

Hello All, I am using teradata as my source stage which is not case specific meaning which will get you ABC and abc when you do a query like where col1 = 'ABC' unless you use the caseSpecific funtion for the specific case. The question I have here is when I try to use the terdata stage and write use...

Thank you for the inputs. As the hash file size limit is 2GB and in the UAT environment I have 24 million records and it could be more in production. Will the hashfile handle this big?

thanks

Hello All, I have total of three dsjobs in which the first two are the extracts from the database joining 5 tables in each with total of 40 columns and in the third job I am sorting and concatinating those two tab delimited output files using ExecSH as before routine and in the dsjob I split into fo...