We have the Datastage server7.5 installed on Unix machine. We need to have a DSN to connect to the database which is on some other unix machine.please let me know it is enough if we create a DSN at the client machine or do we have to change the config file in UNIX?It is very urgent for us and we are not able to solve?pls help me in this regard.Madhavi
To pass parameters to the job we can use Unix shell program. But I do not know exactly how to do that.Plz let me know detail steps to pass the parameter through shell script
Latest Answer : You can use excel file as input by importing the .xls file.step1 --> Go to Administrative Tools -> Data Source (ODBC) --> System DSN. Click on Add button and configure the corresponding .xsl file in your system DSN. Make sure that workbook contains ...
Which we have to use for export the jobs from client to server,if sever running on Unix os and client running on windows os?
How to call a Stored procedure which is in SQL Server database in Datastage job? I want to pass job parameters as one of the SP parameters and for remaining SP parameters , I want to use default values. Also I want to perform transformation on the result set of SP.
1.What is the use of parameters in datastage job?2.What is the difference between datastage 6 and datasttage 7.0?3.Whta is unit testing, system testing and integration testing?4.seheduling the jobs in Datastage?5.What is the difference between datastage 7.1 and datasttage 7.5?6.How to do error handling in datastage?7.how do you remove duplicates in a flatfile?
Are there any ways of passing parameters or values across parallel jobs in a sequencer? Scenario: Job 'A' would execute and based on the result of the Job we want either Job 'B' or Job 'C' to execute. Hence the result of Job 'A' would determine the sequence of operation.
What is the use of $PROJDEF Variable and how can we use this variable to pass the parameters from parameter files ?
Latest Answer : You can run DS jobs using DS desiner and director client components. but in real time we will have huge no of jobs and those has sequnce of order dependency to prform client requirment. in that situation you cant run jobs using DS client components. ...
I know we use them in the project level and also in the job level and also that we can give values at run time(like UN, Pswd etc). Theoratically I understood. But practically unable to implement it. Can
Latest Answer : For example I create a parameter for my hashfile folder like it :
Name: $pHashdir, type:string,def.value:†C:DataStageInput DATAHashâ€
and when I use my hash file in path file name i use just this parameter $pHashdir
and when you run ...
