DSXchange

I thought, if xmeta is storing start time of each jobs, then it is matter of writing select SQL pointing to xmeta LOGGING table. Is there a way to fetch same information(Jobname, StartTime) from xmeta tables ?

I am working on to get a list of DataStage Job/Sequence name whose start time is >= April 2013. Repository has jobs/sequence which are running daily and some which are decommissioned(Not running, but exist). I am in process of identifying which have run for past 2 months. What we did- 1. Using "...

Hi, I am using SCD stage to maintain Dimension tables. The volume of data is more than 20 Million records. What would be the process or steps to calcualte the memory usage of the job or scd stage. Some times the jobs uses maximum of RAM and other jobs does not have sufficient memory. Should I use &q...

Hi, My client does not have any documentation for job flows. For example, there is a DataStage sequence S_BATCH, which calls 10-15 sequence, which inturn calls 50 jobs. Here, I could not figure out what is the flow of each sequence or jobs easily, unless I open each stage(there are about 100 + stage...

hi

I tried using "", but it did not work. I also, tried some escape charecters and many options, but still I could not get the right way to crack it

Hi I am compiling DataStage Jobs and Folder through dscc command, through a batch file. My DataStage Folder name contains space in between names. For example, one of the folder name is "00 Sequence". When there is a space in names, dscc command fails. Can any of you suggest me how to use t...

Do we have to use any modify stage to convert from Varchar(255) to Varchar(40), before target DataSet, to stop taking what ever is in Teradata Enterprise stage metadata by a DataSet.

Thanks,

We are using a Teradata Enterprise stage with custom sql query. The metadata for this query is retrieved through "plug In Metadata". One of these column DataType is VARCHAR and length is 255 in table. After extraction through teradata enterprise stage, next we used a transformer to change ...

Hi

I just used a copy stage between Teradatastage and Lookup stage, input column is CHAR and same column in output is VARCHAR. As I am checking for IsNull() its working fine.
If still there is way of triming in it transformer , please reply.

Hi I am trying to TRIM the Char datatype in Transformer stage. Process --------- Output column from teradata isCHAR datatype. At times when lookup fails the column will not be populated(It must be NULL). BUT when I try to check it for NULL or '' , its not working. When i check the length of the colu...

Hey , I think you are trying to create a new Hashed file and practice. For this you have to go through document's and try it out. Incase you have any errors or problems post in Dsxchange , then we can help you. But no one can send you any hashed file through mail. you must read more on stages and jo...

I don't have clear idea on this...but still when u create a batch ..it also gets created as a job. So I think it will work. Any way an expert answer would make this more clear.

Its a bit big process in migrating 5.x to 7.x. There different way's how you install or upgrade Datastage. 1. If you have done any installition or upgradition of Datastage previously then you can go straight for a migration with minimal support from vendor, any way DSXCHANGE is there :wink: 2. You s...

You can migrate your 5.X to 7.X server to server without much strain. But new features & stages should be handfixed. Use Install and Upgrade Guide's chapter on upgrading and get vendor support.In general you will export each project as a backup first and the upgrade process will automatically up...

To run a pl/sql procedure from Datastage a Stored Procedure (STP) stage can be used. However it needs a flow of at least one record to run. 1. Put any source stage,.eg ODBC stage. 2. A transformer which passes that record through. 3.Put Stored Procedure stage as a destination. Fill in connection par...