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
What is meta stage?
What are the areas of application?
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)
What are iconv and oconv?
Give an idea of system variables.
How can one find bugs in job sequence?
Difference between server jobs & parallel jobs?
What are the types of containers and how to create them?
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.
What is the use of datastage director?
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?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How do you schedule or monitoring the job?
What are routines in datastage?
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