DATASTAGE INTERVIEW QUESTIONS PDF
Important and frequently asked Datastage interview questions with answers. PDF version also available for IBM Datastage questions and answers useful for. A data stage is basically a tool that is used to design, develop and Top 50 Datastage Interview Questions & Answers .. Download PDF. Frequently asked Datastage Interview Questions with detailed answers and examples. Tips and Tricks for cracking Datastage interview. Happy job hunting.
|Language:||English, Spanish, Portuguese|
|ePub File Size:||24.55 MB|
|PDF File Size:||11.15 MB|
|Distribution:||Free* [*Regsitration Required]|
1) What is Datastage? Design jobs for Extraction, Transformation and Loading( ETL). Ideal tool data integration projects such as data warehouses, data marts. Datastage Interview Question and Answers - Download as Word Doc .doc /. docx), PDF File .pdf), Text File .txt) or read online. Priya Menon. wildlifeprotection.info wildlifeprotection.info wildlifeprotection.info wildlifeprotection.info
What are mainframe jobs? A Mainframe job is complied and run on the mainframe , Data Extracted by such jobs is then loaded into the datawarehouse.
What are parallel jobs?
Top 32 Best Datastage Interview Questions And Answers
These are compiled and run on the DataStage server in a similar way to server jobs , but support parallel processing on SMP,MPP and cluster systems How do you use procedure in datastage job? What is odbc stage? Hash file is just like indexed sequential file , this file internally indexed with a particular key value.
Static Hash File. What is a stage variable?
Top FREE Training Tutorials
In Datastage transformation , we can define some variable and define Value from source. What are constraints and derivations?
We can create constraints and derivations with datastage variable.
How do you reject records in a transformer? Through datastage constraint we can reject record. Why do you need stage variables?
A specification that describes the type of data in a column and how the data is converted. What are routines?
In Datastage routine is just like function , which we call in datastage job. Transforms is used to manipulate data within datastage job. What a datastage macro? The available macros are concerned with ascertaining job status.
A job control routine provides the means of controlling other jobs from the current job. A set of one or more jobs can be validated, run ,reset , stopped , scheduled in much the same way as the current job can be.
How many types of stage? All type of job have these stage. Server jobs and parallel jobs can make use of these. BO Questions. Business Intelligence.
Informatica - I. DWH Basic.
Server Components - Repository, Server and Plug-ins. System variables comprise of a set of variables which are used to get system information and they can be accessed from a transformer or a routine.
DataStage Interview Questions And Answers
They are read only and start with an. Many new stages were introduced compared to datastage version 7. In server jobs we have stored procedure stage, CDC Stage ,command stage and generate report option was there in file tab.
In job sequence many stages like startloop activity, end loop activity,terminate loop activity and user variables activities were introduced.Due to the presence fo the Hash key, the Hash file is easier to search than a Sequential file.
These are called as plug-in stages orabulk is used when v have bulk data in oracle then v go for orabulk for other than oracle database we go for bcp stages.
Ans DataStage has four main components which are: Designer: This is where you can create your job, compile and run it. What are parallel jobs? A Job Container contains two unique stages.
For Rows. DataStage , Experienced , Interview Questions. What are orabulk and bcp stages?
- QUIZ QUESTIONS AND ANSWERS PDF
- ROBBINS QUESTION BOOK
- J2EE INTERVIEW QUESTIONS AND ANSWERS FOR FRESHERS PDF
- SBI ASSOCIATE CLERK PREVIOUS YEAR QUESTION PAPER PDF
- JIPMER QUESTION PAPERS PDF
- CDS 2013 QUESTION PAPER PDF
- NET INTERVIEW QUESTIONS FOR 2 YEARS EXPERIENCE PDF
- COMPUTER HARDWARE AND NETWORKING INTERVIEW QUESTIONS WITH ANSWERS PDF
- THE C ANSWER BOOK 2ND EDITION
- MAEVE BINCHY EBOOK