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 |
DataStage Scenario based Interview Questions
What is the difference between orabulk and bcp stages?
how many types of remove the duplicate records?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
how can find maximum salary by using Remove duplicate stage?
how to change left and right links in join stage?
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
Name the different sorting methods in datastage.
How many number of reject links merge stage can have?
what about data stage requirement
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari