DSXchange

Logging in with an expired unix id huh, wow, harry potter is real :o I knew that it is hard to believe but it is true(Not Harry Potter!!! The DataStage bug!!!). The password get exppired at the UNIX level, if a user login at the UNIX they will be validated and prompetd for the new password but Data...

I am sure that some of you have gone through SOX compliance for DataStage and have designed the policies and controls to achieve SOX compliance. At my site also, we are going thorugh putting the controls in DEV, QA and PROD environments. There are few points where security team is not happy with the...

In my DataStage jobs I am getting data from R/3 through IDOC Extract stage. The way I understand is RFC server recieves all the IDOC sent by SAP R/3 on tRFC destination and passes them to DataStage server through PSA. Some member of security team are saying that if you RFC server is recieving only I...

Hi, Due to security requirements, We are planning to get data from same BW to multiple projects. Our plan is we will define the groups and allow them to access only certain projects by restricting file permissions. As I understand, RFC server which is running on DataStage server machine defines the ...

Hi,

I am also running similar environment. Is there a way to force password expiration to the DataStage users, If DataStage is not using telnet.

Thanks,
Dinesh

Try this:

If IsNull(Trim(DSLink14.address2," ")) Or Trim(DSLink14.address2) = "" Then DSLink14.address3 Else DSLink14.address2

I would create a new surrogate key for the dimension and make employee number and SSN number as part of unique alternate key.

Surrogate key will help me other records in fact table to link properly with history records.

If do not want to write any scripts and just do it from DataStage, Just schedule the job 12 times to start at different time interval.

You need to make sure that job finishes before two hours.

Dinesh

Or you can write a bacth job and so some combination of DS Basic and Unix command coding. Here is the code for Batcj job. *Get list of files from input directory. vDirPathName = "/input/" vCmd = "ls -rt " : vDirPathName Call DSExecute("UNIX", vCmd, ScreenOutput, SystemR...

Another solution Create a encrypted text file in some setup directory with user name and password separated by some character. Have the path of setup directory as environment variable in DataStage. To get the password, you need to create a batch job which will execute Unix script to get the password...

"|" character can occur in the ouput file based on multiple reasons. 1. You have "|" character in the hash file with the description. 2. You may have "|" character as delimiter in the sequential file. You need to make sure that it is not there at both places to solve it...

I have job defined in this way ORAOCI9 Stage | File Stage -> Transformer -> file where ORAOCI9 is reference link. This job is processing around 2 million records. It runs upto the last record and then it aborts. In the abort message I only get "Attempting to Cleanup after ABORT raised in stage ...

Is there a way to detect hanging child job from main sequence job? I have main sequence job which calls multiple jobs in a sequence. I am expecting each job to finish in X number of minutes. I want to send e-mail to support group if job does not finish in 2X minutes. I am looking for something like ...

In my batch job, once processing is complete for the file, I compress the file (using gzip) and move the file to archive directory. This functionality works fine, if I run the job manually from director. If I let the job run through scheduler, it give me error when it tries to run gzip. It returns [...

Ken, Your both solutions will work in my case. The main reason why I opted for column approach instead of line approach was beacsue of performance. Calling field function for each row in my view will add extra time for processing. For second solution, One thing I did not mention in the post was the ...