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 |
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
What are datastage sequences?
how to get the unique records on multiple columns by using sequential file stage only
Define data aggregation?
What is Cleanup Resources and when do you use it?
What are the different types of lookups in datastage?
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
In Datastage, how you can fix the truncated data error?
What is use Array size in datastage