Interested to Buy Any Domain ? << Click Here >> for more details...
How can we move a DATASTAGE JOB from Development to Testing
environment with the help of a datastage job using unix
commands.
- 5 Answers
- 22976 Views
- I also Faced
- E-Mail Answers
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 |
What is the use of surrogate key stage?
how to sort two columns in single job in datastage.
what is combinability and non combinability?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
What is meta stage?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How to RD using transformer?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how do u capture duplicates through sort & transformer
Teradata 
