How to create environments and call them? What is the use
defined variables?

Answer Posted / kpk

Environmental Variables can be declared / create in the
DataStage Administrator. In ds admin click on Environmental
variables and select user defined. there you will be able to
define your environmental variable.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meta stage?

896


What are the areas of application?

886


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

696


What are iconv and oconv?

956


Give an idea of system variables.

763






How can one find bugs in job sequence?

1009


Difference between server jobs & parallel jobs?

830


What are the types of containers and how to create them?

735


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3734


What is the use of datastage director?

774


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1236


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3426


How do you schedule or monitoring the job?

852


What are routines in datastage?

1051


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2458