How can we move a DATASTAGE JOB from Development to Testing
environment with the help of a datastage job using unix
commands.
Answers were Sorted based on User's Feedback
Answer / amogh
To EXPORT from DEV:
dsexport /h=hostname /u=username /p=password /job=jobname
DEVServername C:\Path where the .dsx file shld be stored
To Import into ST:
dsimport /h=hostname /u=username /p=password STservername
C:\path from where .dsx file shld be loaded
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ram
Hai
We will export all the jobs in Dev environment and will
import those jobs in Testing environment by using Manager..
I think by using Unix command it is not possible because
jobs are in different environments..
Correct me if i am wrong..
| Is This Answer Correct ? | 8 Yes | 7 No |
Answer / chandrasekhar reddy
First we need to export the all jobs into a single file with .dsx format and prepare one instruction file that file contain jobs exported path,how run the jobs one by one information.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / potter
@ ram, i second ur ans, i dunno if its possible tro unix
cuz, the access credentials in dev and test wont be the
same. Cuz ppl in dev wont b givn access to test DB.
| Is This Answer Correct ? | 0 Yes | 1 No |
in aggregator , how can i get the sum in readable format
Can you explain engine tier in information server?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
wt is the diff b/w odbc and oracle stage
What all are the different way to run a job?
If the job aborted in a sequencer, how can we start that from the previews successful job.
What is the difference between the local container and shared container?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
What is the process of killing a job in datastage?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
what is the use of materialized view?