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 to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
what is the use of invokation id
what is combinability and non combinability?
Explain datastage architecture?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
what is datastage job Monitoring
How do you run datastage job from the command line?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How can we improve performance of data stage jobs?
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz