What are Routines and where/how are they written and have you written any routines before?  Â

Question:What are Routines and where/how are they written and have you written any routines before?   ?

Answer: Routines are stored in the Routines branch of the DataStage Repository, where you can create, view or edit. The following are different types of routines:<BR>&nbsp;&nbsp; 1) Transform functions<BR>&nbsp;&nbsp; 2) Before-after job subroutines<BR>&nbsp;&nbsp; 3) Job Control routines

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Real Estate Management System Software

Real Estate Management Software is an advanced end-to-end Real Estate Office Management System that enables Real Estate Agencies to manage more effectively, search prorty details, keep property owner data etc. Web-based tracking and accounting solution ideal for commercial, residential housing....

What are OConv () and Iconv () functions and where are they used?Â

Question:What are OConv () and Iconv () functions and where are they used? ?

Answer: IConv() - Converts a string to an internal storage format<BR>OConv() - Converts an expression to an output format.

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Customer Resource Management Software

CRM software is designed to help businesses in manageing their customer data and customer interaction, access business information, automate sales, marketing and customer support and also manage employee, vendor and partner relationships. ...

How did you connect to DB2 in your last project?

Question:How did you connect to DB2 in your last project??

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Customer Resource Management Software

CRM software is designed to help businesses in manageing their customer data and customer interaction, access business information, automate sales, marketing and customer support and also manage employee, vendor and partner relationships. ...

What is Metastage?

Question:What is Metastage??

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Customer Resource Management Software

CRM software is designed to help businesses in manageing their customer data and customer interaction, access business information, automate sales, marketing and customer support and also manage employee, vendor and partner relationships. ...

Do you know about INTEGRITY/QUALITY stage?

Question:Do you know about INTEGRITY/QUALITY stage??

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Customer Resource Management Software

CRM software is designed to help businesses in manageing their customer data and customer interaction, access business information, automate sales, marketing and customer support and also manage employee, vendor and partner relationships. ...

Explain the differences between Oracle8i/9i?

Question:Explain the differences between Oracle8i/9i??

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

SMS Management System Software

This software used to Send bulk SMS (short text messages) from your computer and assists you to rapidly connect with your customers and staff, communicate with them easily and cheaply, using latest technology that help to generate bulk SMS on just one click to all the database....

How good are you with your PL/SQL?

Question:How good are you with your PL/SQL??

Answer: On the scale of 1-10 say 8.5-9&nbsp;

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Human Resource Management Software

Powerful, configurable software for human resources management that is easy to manage and remarkably cost-effective, whatever the size of your company. Now there’s a smarter, more efficient way to handle all of your people-related activities. Easy-to-use system manages the full hire-to-retire lifecycle...

Did you work in UNIX environment?Â

Question:Did you work in UNIX environment? ?

Answer: Yes. One of the most important requirements.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Hospital Management System Software

Hospital Management System (HMS) Software is developed for multispeciality hospitals, to cover a wide range of hospital administration and management processes with financial accounting, voucher entry, pharmacy, patients module etc features...

What other ETLs you have worked with?

Question:What other ETLs you have worked with??

Answer: Informatica and also DataJunction if it is present in your Resume.

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Library Management System Software

Our Library Management Softare offers complete library management modules and automation solution that enables information providers, information managers, resource incharge, resource managers & librarians to manage & disseminate information & resources....

What versions of DS you worked with?

Question:What versions of DS you worked with??

Answer: DS 7.0.2/6.0/5.2

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Real Estate Management System Software

Real Estate Management Software is an advanced end-to-end Real Estate Office Management System that enables Real Estate Agencies to manage more effectively, search prorty details, keep property owner data etc. Web-based tracking and accounting solution ideal for commercial, residential housing....

What is DS Designer used for - did u use it?

Question:What is DS Designer used for - did u use it??

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Real Estate Management System Software

Real Estate Management Software is an advanced end-to-end Real Estate Office Management System that enables Real Estate Agencies to manage more effectively, search prorty details, keep property owner data etc. Web-based tracking and accounting solution ideal for commercial, residential housing....

What is DS Administrator used for - did u use it?

Question:What is DS Administrator used for - did u use it??

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

School Management System Software

This is One of the best School management system software in the world. School Software offers complete professional institute management system administration, library, accounting, inventory, etc for all the school activities management...

What is DS Director used for - did u use it?

Question:What is DS Director used for - did u use it??

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Hospital Management System Software

Hospital Management System (HMS) Software is developed for multispeciality hospitals, to cover a wide range of hospital administration and management processes with financial accounting, voucher entry, pharmacy, patients module etc features...

What is DS Manager used for - did u use it? Â

Question:What is DS Manager used for - did u use it?  ?

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

School Management System Software

This is One of the best School management system software in the world. School Software offers complete professional institute management system administration, library, accounting, inventory, etc for all the school activities management...

What are Static Hash files and Dynamic Hash files?

Question:What are Static Hash files and Dynamic Hash files??

Answer: As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size.

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Customer Resource Management Software

CRM software is designed to help businesses in manageing their customer data and customer interaction, access business information, automate sales, marketing and customer support and also manage employee, vendor and partner relationships. ...

What is Hash file stage and what is it used for?Â

Question:What is Hash file stage and what is it used for? ?

Answer: Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance.&nbsp;&nbsp;&nbsp;

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

SMS Management System Software

This software used to Send bulk SMS (short text messages) from your computer and assists you to rapidly connect with your customers and staff, communicate with them easily and cheaply, using latest technology that help to generate bulk SMS on just one click to all the database....

Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have taken in doing so?

Question:Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have taken in doing so??

Answer: Yes. The following are some of the steps; I have taken in doing so:<BR>1) Definitely take a back up of the whole project(s) by exporting the project as a .dsx file<BR>2) See that you are using the same parent folder for the new version also for your old jobs using the hard-coded file path to work.<BR>3) After installing the new version import the old project(s) and you have to compile them all again. You can use &#39;Compile All&#39; tool for this.<BR>4) Make sure that all your DB DSN&#39;s are created with the same name as old one&#39;s. This step is for moving DS from one machine to another.<BR>5) In case if you are just upgrading your DB from Oracle 8i to Oracle 9i there is tool on DS CD that can do this for you.<BR>6) Do not stop the 6.0 server before the upgrade, version 7.0<BR>install process collects project information during the upgrade. There is NO rework (recompilation of existing jobs/routines) needed after the upgrade.

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Customer Resource Management Software

CRM software is designed to help businesses in manageing their customer data and customer interaction, access business information, automate sales, marketing and customer support and also manage employee, vendor and partner relationships. ...

Did you Parameterize the job or hard-coded the values in the jobs?

Question:Did you Parameterize the job or hard-coded the values in the jobs??

Answer: Always parameterized the job. Either the values are coming from Job Properties or from a 'Parameter Manager' – a third part tool. There is no way you will hard–code some parameters in your jobs. The often Parameterized variables in a job are: DB DSN name, username, password, dates W.R.T for the data to be looked against at.

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Hospital Management System Software

Hospital Management System (HMS) Software is developed for multispeciality hospitals, to cover a wide range of hospital administration and management processes with financial accounting, voucher entry, pharmacy, patients module etc features...

How do you merge two files in DS?

Question:How do you merge two files in DS??

Answer: <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: &#39;Times New Roman&#39;; mso-bidi-font-family: &#39;Times New Roman&#39;; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Either used 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.</SPAN>

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Real Estate Management System Software

Real Estate Management Software is an advanced end-to-end Real Estate Office Management System that enables Real Estate Agencies to manage more effectively, search prorty details, keep property owner data etc. Web-based tracking and accounting solution ideal for commercial, residential housing....

Tell me the environment in your last projects

Question:Tell me the environment in your last projects?

Answer: <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt">Give the OS of the Server and the OS of the Client of your recent most project<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

School Management System Software

This is One of the best School management system software in the world. School Software offers complete professional institute management system administration, library, accounting, inventory, etc for all the school activities management...

How many jobs have you created in your last project?

Question:How many jobs have you created in your last project??

Answer: <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: &#39;Times New Roman&#39;; mso-bidi-font-family: &#39;Times New Roman&#39;; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody</SPAN>

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

School Management System Software

This is One of the best School management system software in the world. School Software offers complete professional institute management system administration, library, accounting, inventory, etc for all the school activities management...

What are the often used Stages or stages you worked with in your last project?

Question:What are the often used Stages or stages you worked with in your last project??

Answer: <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: &#39;Times New Roman&#39;; mso-bidi-font-family: &#39;Times New Roman&#39;; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">A) Transformer, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, Hash, ODBC, Aggregator, Sort.<BR style="mso-special-character: line-break"><BR style="mso-special-character: line-break"></SPAN>

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Human Resource Management Software

Powerful, configurable software for human resources management that is easy to manage and remarkably cost-effective, whatever the size of your company. Now there’s a smarter, more efficient way to handle all of your people-related activities. Easy-to-use system manages the full hire-to-retire lifecycle...

Explain your last project and your role in it.?

Question:Explain your last project and your role in it.??

Answer:

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Hospital Management System Software

Hospital Management System (HMS) Software is developed for multispeciality hospitals, to cover a wide range of hospital administration and management processes with financial accounting, voucher entry, pharmacy, patients module etc features...

Waht is the frequency of log Updated..?

Question:Waht is the frequency of log Updated..??

Answer: Whenever commit,checkpoint or redolog buffer is 1/3rd full<BR>

Tags:Interview Questions, Oracle, Database Administration,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Human Resource Management Software

Powerful, configurable software for human resources management that is easy to manage and remarkably cost-effective, whatever the size of your company. Now there’s a smarter, more efficient way to handle all of your people-related activities. Easy-to-use system manages the full hire-to-retire lifecycle...

What is the use of TNSNAME.ORA and LISTENER.ORA files

Question:What is the use of TNSNAME.ORA and LISTENER.ORA files?

Answer: Tnsnames.ora is used to connect to the remote db. To get the connection listener.ora should be configured at the server and it should be up and running.<BR>

Tags:Interview Questions, Oracle, SQL Plus,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Customer Resource Management Software

CRM software is designed to help businesses in manageing their customer data and customer interaction, access business information, automate sales, marketing and customer support and also manage employee, vendor and partner relationships. ...