How can i approach to write datastage 7.5 Certification?
and how much they will charge for examination .What
exactly should i do? Can anyone guide me plz?
- 2 Answers
- 6563 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkat
U can write test at any authorized centers like NIIT.they
charge arround 4000/-.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / amulya kumar panda
U can write test at any authorized centers .they
charge arround 7200/-
| Is This Answer Correct ? | 0 Yes | 0 No |
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
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.
What is PX?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
source file contains 100 records, i want 10 records in target file how it possible in datastage
How many types of sorting methods are available in datastage?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
Have you used Unstructured data?
Define oconv () and iconv () functions in datastage?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
How many types of stage?
What are the different kinds of views available in a datastage director?
Teradata 
