How to initialize environment variables?
Answers were Sorted based on User's Feedback
Answer / kpk
to initialize environmental variables goto DS Admin, click
on environmental variable button. then proceed to user
defined.. there u will be able to provide user defined EV's.
you need to define the values in the DS admin, and you can
call them in the DS job parameter using the magic word
"PROJDEF".
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / archana
First u can initialize env variables in datastage administrator,then click on Environmental variable button,Next write whatever u defined(server,username,pwd).
next open ds designer u can call those environmental variables in this designer by using job parameter window
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chenna
what is difference between the changecaputer stage and
difference stage?
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sowmiya
what is difference between the changecaputer stage and
difference stage?
changecaputer stage provide the data only for after link .
Difference stage given the value of the before and after link.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is a force compile
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
what r the sources u need to create the datastage?
What are the difference types of stages?
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
why dataset ?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
How a server job can be converted to a parallel job?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
which r the connectors used in san?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
Can you explain repository tables in datastage?