Interested to Buy Any Domain ? << Click Here >> for more details...
How to create environments and call them? What is the use
defined variables?
- 2 Answers
- 9132 Views
- HCL, ME, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / viji
We can call the environmental variable by using job properties tab of sequence and parallel datastage jobs
| Is This Answer Correct ? | 1 Yes | 0 No |
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Name the command line functions to import and export the DS jobs?
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,
how to abort the job its matain duplicates?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is materialized view used datastage?
Demonstrate experience in maintaining quality process standards?
What is orabulk stage?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
What is the difference between validated and compiled in the datastage?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
Teradata 
