Interview Questions.

Question 1. Explain Data Stage?

Answer :

A statistics level is without a doubt a tool that is used to layout, develop and execute many programs to fill diverse tables in statistics warehouse or records marts.Learn extra about DataStage in this insightful weblog post now.

Question 2. Tell How A Source File Is Populated?

Answer :

We can generate a supply report in numerous ways together with via creating a SQL question in Oracle, or  with the aid of the use of row generator extract tool and many others.

Oracle 10g Interview Questions
Question 3. Write The Command Line Functions To Import And Export The Ds Jobs?

Answer :

To signify the DS jobs, dsimport.Exe is used and to export the DS jobs, dsexport.Exe is used.

Question four. Differentiate Between Datastage 7.Five And 7.0?

Answer :

In Datastage 7.Five diverse new stages are introduced for greater sturdiness and smooth overall performance, such as Procedure Stage, Command Stage,and so forth.

Oracle 10g Tutorial
Question five. Explain Merge?

Answer :

Merge way to merge  or greater tables. The two tables are merged on the origin of Primary key columns in both the tables.Interested in studying DataStage? Well, we've got the in-depth DataStage Courses to give you a head begin on your profession.

Shell Scripting Interview Questions
Question 6. Differentiate Between Data File And Descriptor File?

Answer :

As the name says, facts files includes the information and the descriptor record contains the information about the facts inside the facts files.

Question 7. Differentiate Between Data Stage And Informatica?

Answer :

In datastage, there may be a belief of separation, parallelism for node configuration. While, there may be no notion of separation and parallelism in informatica for node configuration. Also, Informatica is more scalable than Datastage. Datastage is greater smooth to apply in comparison to Informatica.

Shell Scripting Tutorial Microstrategy Interview Questions
Question eight. Explain Routines And Their Types?

Answer :

Routines are essentially organization of capabilities this is described by way of DS supervisor. It may be known as through transformer level. Routines are of 3 types including, parallel workouts, server routines and main body exercises.

Question 9. How Can We Write Parallel Routines In Data Stage Px?

Answer :

We can mention parallel workouts in C or C++ compiler. Such routines are also evolved in DS manager and can be known as from transformer stage.

Informatica Interview Questions
Question 10. What Is The Procedure Of Removing Duplicates, Without The Remove Duplicate Stage?

Answer :

Duplicates may be detached by way of the usage of Sort stage. We can use the opportunity, as allow reproduction = false.

Microstrategy Tutorial
Question eleven. What Steps Should Be Taken To Recover Datastage Jobs?

Answer :

In order to get better presentation of Datastage jobs, we must first create the baselines. Secondly, we ought to no longer use handiest one float for presentation testing. Thirdly, we have to work in increase. Then, we need to appraise information skews. Then we have to separate and resolve the issues, one at a time. After that, we ought to allocate the record systems to do away with bottlenecks, if any. Also, we must no longer include RDBMS in start of trying out section. Last but no longer the least, we need to recognize and examine the to be had tuning knobs.

IBM Cognos Interview Questions
Question 12. Compare And Contrast Between Join, Merge And Lookup Stage?

Answer :

All the three are diverse from every different inside the manner they use the reminiscence garage, compare input necessities and how they deal with numerous data . Join and Merge desires minimum memory as compared to the Lookup stage.

Oracle 10g Interview Questions
Question 13. Describe Quality Stage?

Answer :

Quality level is likewise known as as Integrity level. It assists in integrating diverse styles of data from unique assets.

Informatica Tutorial
Question 14. Describe Job Control?

Answer :

Job manage can be first-rate executed by way of the usage of Job Control Language (JCL). This tool is used to execute diverse jobs concurrently, without using any kind of loop.

Question 15. Contrast Between Symmetric Multiprocessing And Massive Parallel Processing?

Answer :

In Symmetric Multiprocessing, the hardware sources are communal by means of processor. The processor has one working device and it communicates thru shared reminiscence. While in Massive Parallel processing, the CPU contact the hardware sources absolutely. This form of processing is also called as Shared Nothing, as not anything is not unusual on this. It is quicker than the Symmetric Multiprocessing.

Data Warehouse ETL Toolkit Interview Questions
Question 16. Write The Steps Required To Kill The Job In Datastage?

Answer :

To spoil the task in Datasatge, we need to kill the person processing ID.

IBM Cognos Tutorial
Question 17. Contrast Between Validated And Compiled In The Datastage?

Answer :

In Datastage, validating a task method, executing a job. While validating, the Datastage engine assessments whether or not all the important properties are given or no longer. In other case, even as compiling a task, the Datastage engine exams that whether or not all the given property are suitable or now not.

Teradata Interview Questions
Question 18. How We Can Run Date Conversion In Datastage?

Answer :

We can use date conversion function for that reason i.E. Oconv (Iconv(Filedname,”Existing Date Format”),”Another Date Format”).

Shell Scripting Interview Questions
Question 19. What Is The Need Of Exception Activity In Datastage?

Answer :

All the levels after the exception pastime in Datastage are run in case of any unusual blunders occurs at the same time as executing the process sequencer.Learn how the DataStage Training Videos  can take your career to the subsequent degree!

Data Warehouse ETL Toolkit Tutorial
Question 20. Explain Apt_config In Datastage?

Answer :

It is the surroundings variable that is used to recognize the *.Apt record in Datastage. It is also used to keep the node facts, scratch statistics and disk storage facts.

PL/SQL Interview Questions
Question 21. Write The Different Types Of Lookups In Datastage?

Answer :

There are two types of Lookups in Datastage i.E. Normal research and Sparse lookup.

Question 22. How We Can Covert Server Job To A Parallel Job?

Answer :

We can convert a server activity in to a parallel activity through the use of Link Collector and IPC Collector.

Teradata Tutorial
Question 23. Explain Repository Tables In Datastage?

Answer :

In Datastage, the Repository is 2d name for a statistics warehouse. It may be federalized as well as circulated.

Oracle 11g Interview Questions
Question 24. Describe Oconv () And Iconv () Functions In Datastage?

Answer :

In Datastage, OConv () and IConv() functions are used to convert formats from one layout to every other i.E. Conversions of time, roman numbers, radix, date, numeral ASCII and many others. IConv () is frequently used to trade codecs for gadget to apprehend. While, OConv () is used to alternate codecs for customers to understand.

Microstrategy Interview Questions
Question 25. Define Usage Analysis In Datastage?

Answer :

In Datastage, Usage Analysis is performed within few clicks. Launch Datastage Manager and proper click on on job. Then, pick Usage Analysis.

Oracle 11g Tutorial
Question 26. How We Can Find The Number Of Rows In A Sequential File?

Answer :

To locate rows in chronical report, we can use the System variable @INROWNUM.

Abinitio Interview Questions
Question 27. Contrast Between Hash File And Sequential File?

Answer :

The handiest dissimilarity between the Hash report and Sequential document is that the Hash report shops records on hash algorithm and on a hash key value, while sequential document doesn’t have any key cost to store the information. Hence we can say that hash key function, searching in Hash record is faster than in sequential report.

Informatica Interview Questions
Question 28. How We Can Clean The Datastage Repository?

Answer :

We can easy the Datastage repository via the Clean Up Resources capability within the Datastage Manager.

Question 29. How We Can Called Routine In Datastage Job?

Answer :

We can name a recurring from the transformer level in Datastage job.

TeraData DBA Interview Questions
Question 30. Differentiate Between Operational Datastage (ods) And Data Warehouse?

Answer :

We can say, ODS is a small statistics warehouse. An ODS doesn’t have records for extra than 1 year even as a records warehouse have unique records about the entire enterprise.

Question 31. For What Nls Stand For In Datastage?

Answer :

NLS stand for National Language Support. It may be used to combine various languages together with French, German, and Spanish and many others. Inside the records, needful for processing by way of records warehouse.

Question 32. Can You Explain How Could Anyone Crash The Index Before Loading The Data In Target In Datastage?

Answer :

In Datastage, we will crash the index earlier than loading the records in goal by using the use of the Direct Load functionality of SQL Loaded Utility.

Talend Interview Questions
Question 33. Does Datastage Support Gradually Changing Dimensions ?

Answer :

Yes,Version 8.5 + supports this selection in datastage.

IBM Cognos Interview Questions
Question 34. How Complicated Jobs Are Implemented In Datstage To Recover Performance?

Answer :

In order to recover overall performance in Datastage, it is recommended, no longer to apply more than 20 degrees in every process. If you need to use extra than 20 tiers then it is really useful to apply next job for the ones ranges.

Question 35. Name The Third Party Tools That Can Be Used In Datastage?

Answer :

The 0.33 celebration tools that can be utilized in Datastage, are Autosys, TNG and Event Co-ordinator.

Question 36. Describe Project In Datastage?

Answer :

When ever we begin the Datastage patron, we're asked to join to a Datastage venture. A Datastage mission have Datastage jobs, integrated apparatus and Datastage Designer or User-Defined components.

Data Warehouse ETL Toolkit Interview Questions
Question 37. What Types Of Hash Files Are There?

Answer :

There are two types of hash files in which might be Static Hash File and Dynamic Hash File.

Question 38. Describe Meta Stage?

Answer :

In Datastage, MetaStage is used to store metadata that is beneficial for statistics lineage and facts evaluation.

Question 39. Why Unix Environment Is Useful In Datastage?

Answer :

It is beneficial in Datastage due to the fact every now and then one has to write down UNIX applications along with batch applications to elevate batch processing and so forth.

Question 40. Contrast Between Datastage And Datastage Tx?

Answer :

Datastage is a tool from ETL i.E. Extract, Transform and Load and Datastage TX is a device from EAI i.E. Enterprise Application Integration.Learn extra about the ETL manner in this insightful weblog now.

Teradata Interview Questions
Question forty one. What Is Size Of A Transaction And An Array Means In A Datastage?

Answer :

Transaction length approach the variety of row written before committing the account in a desk. An array size way the variety of rows written/read to or from the table respectively.

Question forty two. Name The Various Types Views In A Datastage Director?

Answer :

There are 3 varieties of views in a Datastage Director i.E. Log View, Job View and Status View.

PL/SQL Interview Questions
Question 43. What Is The Use Of Surrogate Key?

Answer :

Surrogate secret is in the main used for buying records faster. It makes use of catalog to carry out the retrieval operation.

Question forty four. How Discarded Rows Are Processed In Datastage?

Answer :

In the Datastage, the discarded rows are controlled with the aid of constraints in transformer. We can either area the discarded rows within the homes of a transformer or we will create a brief storage for discarded rows with the help of REJECTED command.

Question 45. Contrast Between Odbc And Drs Stage?

Answer :

DRS level is faster than the ODBC degree because it makes use of local databases for connectivity.

Question 46. Describe Orabulk And Bcp Stages?

Answer :

Orabulk degree is used to keep large quantity of statistics in a single goal table of Oracle database. The BCP level is used to save huge amount of facts in a single target desk of Microsoft SQL Server.

Question 47. Describe Ds Designer?

Answer :

The DS Designer is used to make paintings vicinity and add many hyperlinks to it.

Question 48. What Is The Need Of Link Partitioner And Link Collector In Datastage?

Answer :

In Datastage, Link Partitioner is used to split statistics into various elements through certain partitioning techniques. Link Collector is used to accumulate data from many walls to a unmarried information and keep it inside the target desk.