what is the new version in Datastage ? what is the diff b/t
New vesion & 7.5 version?
Answer Posted / chenna
New version of datastage was IBM WebSphere datastage 8.1.0
PX
but new version haveing some enhancements.
that are it support any webbrowsers,its haveing some stages
like QUALITY STAGE &Profile Stage .
the new version IBM WebSphere datastage 8.1.0 is haveing a
new transformer stage here we have some new futures.
comper to 7.5 it is haveing a better perfamence.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the different options associated with dsjob command?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
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 the difference between informatica and datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is quality stage?
How can you write parallel routines in datastage PX?
What is the purpose of pivot stage and types of containers in datastage
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.
Difference between server jobs & parallel jobs?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Can we use target hash file as a lookup ?