Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bond
YOU CAN REFFER FROM THE DATASTAGE DIRECTORY OR EACH JOB
WILL CREATE LOG FILE AND STORED IN REPOSITARY.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is the use of surogate key in datastage
What are routines in datastage?
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:
What is ibm datastage flow designer?
How many types of hash files are there?
What is quality stage?
Highlight the main features of datastage?
How to find value from a column in a dataset?
What can we do with datastage director?
Describe link sort?
What is the process of killing a job in datastage?
What a datastage macro?
How do you generate sequence number in datastage?
What is "fatal error/rdbms code 3996" error?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
