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 100 records how can I load at a time from the single time
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
Difference between server jobs & parallel jobs?
what is Audit table?Have u use audit table in ur project?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
what is the use of invokation id
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
what are the types of nodes
what is the use of surogate key in datastage
To see hidden files in LINIX?
Tell me Wt main advantage of Stage varibles? Project level hints?