Datastage Interview Questions and Answers for freshers and experienced.
Name the different versions of Datastage you worked with?Answer : The different version of Datastage are DS 7.0.2/6.0/5.2.
In DS 6.0 and latest versions, what is the use of Link-Partitioner and Link-Collector ?
Answer : Link Partitioner is used for partitioning the data whereas Link Collector is used for collecting the partitioned data.
Describe how you rename all of the jobs to support your new File-naming conventions in Datastage?
Answer : Wee need to create a Excel spreadsheet with new and old names. Then we have to export the whole project as a dsx. Finally, write a Perl program, which can do a simple rename of the strings looking up the Excel file.
What are the different types of Parallel Processing?
Answer : Parallel Processing is broadly classified into two types.
- SMP - Symmetrical Multi Processing.
- MPP - Massive Parallel Processing.
Answer : DWH's are typically read only, batch updated on a scheduleODS's are maintained in more real time, trickle fed constantly
What is the default cache size? Explain how do you change the cache size if needed?
Answer : The default cache size is 256 MB. However, we can increase it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there.
Describe how can you handle Date convertions in Datastage ? Like the conversion of mm/dd/yyyy format to yyyy-dd-mm?
Answer : We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/M
Is it possible to calculate a hash total for an EBCDIC file and have the hash total stored as EBCDIC using Datastage ?
Answer : Currently, the total is converted to ASCII, even tho the individual records are stored as EBCDIC.
Explain how can you merge two files in Datastage?
Answer : We can merge two file by either using Copy command as a Before-job subroutine if the metadata of the 2 files are same or created a job to concatenate the 2 files into one if the metadata is different.
How can you connect to DB2 from Datastage?
Answer : By using DB2 ODBC drivers.
What do you mean by Sequencers?
Answer : Sequencers are job control programs that execute other jobs with preset Job parameters.
Explain how can you execute Datastage job from command line prompt?
Answer : Using "dsjob" command as follows. dsjob -run -jobstatus projectname jobname
Explain how do you rename all of the jobs to support your new File-naming conventions?
Answer : We need to create a Excel spreadsheet with new and old names. Export the whole project as a dsx. Write a Perl program, which can do a simple rename of the strings looking up the Excel file. Then import the new dsx file probably into a new project for testing. Recompile all jobs. Be cautious that the name of the jobs has also been changed in your job control jobs or Sequencer jobs. As such, you have to make the necessary changes to these Sequencers.
Related Posts
No comments :