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 |
What are the differences between datastage and informatica?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
How to find value from a column in a dataset?
how do u reduce warnings
how can u connect the client system directly at any time?
What are routines in datastage? Enlist various types of routines.
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
can any one tell me how to install datastage 8.1 in windows xp with wizard
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
what is parameterset?