DSXchange

There were formatting issues with the job design in the prev. post. Plz chk the following. Job Design: ODBC | LOOKUP ===> TRANS ===> SEQ_FILE ^ | TRANS ^ | SEQ_FILE Is it possible that the Objects created for the transformer be purged and the job be recompiled and run ..Iam assuming here that Trans...

My requirement is to access MS Access DB from DataStage 7.5.1 parallel jobs. Can i use the ODBC stage to do that. Else what is the best way to do it. The data volume that I am looking at is not huge. Thanks in Advance. Naren We had connected to MSAccess ..U will need a DSN (UserDSN/SystemDSN) to be...

Ram, Can you share, with us the logic, you have been using to find if the file exist or not with in the unix script. Hope that should help us when such a requirement come up. Thanks in advance. Sure Sree right now this is what iam doing . if [ ! -f $lookupfile ] then echo "Lookup file [$lookup...

Iam kind of getting that , correct me if iam wrong here , if i use wait for file activity i can look for appearance of the file and timeout after a certain time .that way will be a way to distinguish if the file exists or not right ? ... Is that possible to add logic for branching in that case ? or ...

Hi Folks I have a requirement where certain extract and transformation need to happen if there is a file that is avaialable . quite simply if a look-up file is available use that to do some lookup and tranform else do another process . As of now , i have split that into multiple jobs and i use shell...