DSXchange

Thanks Ray.

Thats what i was trying to figure out if i can get access to virtual datasets.But as they are released with job termination then we have to do the work in bits and pieces.

Hi I was seeking some suggestions for designing a job restartability scenario. Scenario : I have a DS job consisting of StageA,StageB and StageC.Suppose for incoming 100 rows StageA and StageB have done their processing of 100 records but job fails at StageC . Is it possible to reuse the already pro...

i am trying to compile one of my jobs and the error i get is :
message handler file .msh not found.

where can i get this file from or what excatly is supposed to be done?

Thanks

Hi I am using open command option in teradata enterprise stage for deleting data from a table for specific dates prior to insert. But i am getting an error message : Unrecognized argument: <database_name>.<table_name> i am hardcoding the databasename and tablename but still same job aborts with same...

i checked it and DS substitutes NULLs after joins only for datasets and not for databases.

Hi I am encountering a strange thing while performing join in Datastage. When i perform a left/right join on on two datasets in DS then it substitutes Null for non matching records but when i perform a join between a dataset and teradata enterprise stage then it substitutes : 1) Blanks for character...

Hi, Yes, the Enterprise Stage does an FastLoad and Insert Select statement. However, we had a requirement of Upsert hence were interested in using Multiload. We were thinking along the lines that one can apply change capture to identify inserts and updates. However with Updates one is still stuck wi...

Details:- Teradata V2r5 Datastage 7.5x2 OS Unix I have a simple job of sequential file + Transform + Multiload. Within MultiLoad Stage in the Output file path i mention a directory having permissions ( drwxr-xr-x) and no file is mentioned in the Report Files. If one gives wrong password, the job han...

Hi

Can anyone throw some light on PHANTOMs in Datastage.

Thanks

Hi

I have to capture the file name of the file which i am currently loading into a database and insert this file name along with the data in database.

How can this be done in datastage, i am reading fix width files.

Thanks

Hi

I am loading fixed width files specifying a file pattern using Teradata Enterprise stage.
It gives me error :

RT_SC19/OshExecuter.sh[20]:668864 Segmentation fault (coredump)
Parallel job reports failure (code 139)

Can anyone help me in fixing this error.

Thanks

Hi

How could a product join be inmplemented in Datastage Px as join stage supports only left , right , inner and full outer joins.

Thanks

Hi, Simply replcae the constant with a lookup to get runtime value. The max value gained from the lookup should be loaded to memory so you should have no problem. IHTH, If i use lookup then there is no key values on which i can specify the lookup. So i will get Nulls returned for 1 table in Lookup ...

It's easy enough in DataStage - if the target table has the extra column, simply use the new metadata (table definition) an assign the constant 1000 to that column for all rows. Probably easiest is a ... The constant value of max_value column is determined at the time of job execution and is not pr...

I have a data file like : name|age drew|23 moore|45 I have another query returning a max value of some column,say max_value be column name and its max value be 1000. Now i want a output file like name|age|max_value drew|23|1000 moore|45|1000 How can this be done with best efficient way in Datastage....