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 |
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
what is data mapping
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
what is use of SDR function?
how CAN we remove duplicates in dataset?
what is usage of datastage with materialized views
Tell me the syntax of Configuration file?
can we use sequential file as a lookup
What is the difference between informatica and datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
I have 100 records how can I load at a time from the single time
Explain the scenarios where sequential file stage runs in parallel?