Interested to Buy Any Domain ? << Click Here >> for more details...
How to initialize environment variables?
- 4 Answers
- 14161 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
What is the function in Transformer stage can act as Rank Function in oracle
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: <min_lvl>”, where <min_lvl> is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.
how to capture rejected data by using join stage not for lookup stage. please let me know
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
What is the difference between Datastage 7.5 and 7.0?
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
Have you have ever worked in unix environment and why it is useful in datastage?
Teradata 
