Interview Questions.

Question 1. What Is Meant By Teradata Gateway?

Answer :

Just like channel motive force, Teradata Gateway acts as a medium of verbal exchange among the Parse Engine and packages which are connected to community customers. Only one Gateway is assigned per node.

Question 2. Does Sdlc Changes When You Use Teradata Instead Of Oracle?

Answer :

If the teradata goes to be simplest a information base manner It gained’t alternate the System development existence cycle (SDLC).

If you're going to use the teradata utilities then it's going to exchange the Architecture or SDLC.

If your schema is going to be in 3NF then there gained’t be large in change.

Oracle 10g Interview Questions
Question three. How Many Codd’s Rules Are Satisfied By Teradata Database?

Answer :

There are 12 codd’s regulations implemented to the teradata database.

Question four. Steps To Create A Data Model?

Answer :

Get enterprise requirements.
Create High Level Conceptual Data Model.
Create Logical Data Model.
Select goal DBMS in which records-modeling tool creates the bodily schema.
Create trendy abbreviation file consistent with commercial enterprise general.
Oracle 10g Tutorial
Question 5. What Is Oltp?

Answer :

OLTP stands for Online Transaction Processing. OLTP uses normalized tables to quick file big amounts of transactions even as ensuring that these updates of facts arise in as few locations as feasible. Consequently OLTP database are designed for recording the each day operations and transactions of a commercial enterprise. E.G. A timecard machine that supports a huge production environment must file correctly a large range of updates all through important durations like lunch hour, breaks, startup and near of work.

Informatica Interview Questions
Question 6. Differentiate Database Data And Data Warehouse Data?

Answer :

Data in a Database is Detailed or Transactional, Both Readable and Write capable and present day.

Data in facts warehouse is unique and summarized, garage region for historical records.

Question 7. What Is A Three-tier Data Warehouse?

Answer :

The 3-tier differs from the 2-tier structure through strictly enforcing a logical separation of the graphical person interface, enterprise good judgment, and information. The 3-tier is broadly used for records warehousing today. Organizations that require greater overall performance and scalability, the three-tier structure may be more suitable. In this architecture, statistics extracted from legacy structures is cleansed, transformed, and saved in excessive –speed database servers, that are used because the target database for the front-give up records get entry to.

Informatica Tutorial Teradata Interview Questions
Question 8. What Is Data Mining?

Answer :

Analyzing of huge volumes of enormously simple facts to extract critical trends and new, higher stage statistics. For example, a facts-mining software might analyze hundreds of thousands of product orders to decide tendencies amongst pinnacle-spending clients, which includes their likelihood to purchase again, or their likelihood to replace to a specific vendor. 

Question 9. What Is Real Time And Near Real Time Data Warehousing?

Answer :

The difference among real time and near real time may be summed up in a single phrase: latency. Latency is the time lag that is between an interest of entirety and the finished hobby records being available in the records warehouse. In real time, the latency is negligible whereas in near real time the latency is a tangible time body inclusive of  hours.

Oracle Interview Questions
Question 10. What Is Ods?

Answer :

An operational information store (ODS) is in the main a “dump” of relevant facts from a very small number of structures (frequently just one) commonly with very little transformation. The advantages are an advert hoc query database, which does no longer have an effect on the operation of structures required to run the business. ODS’s generally cope with information “raw” and “modern-day” and might solution a limited set of queries as a end result.

Teradata Tutorial
Question 11. What Is Real Time Data Warehousing?

Answer :

Real-time facts warehousing is a mixture of two things:
real-time activity and
facts warehousing.
Real-time pastime is interest this is going on right now. The activity will be something together with the sale of widgets. Once the interest is entire, there may be information approximately it. Data warehousing captures enterprise hobby facts. Real-time records warehousing captures business interest data as it takes place. As soon as the enterprise hobby is complete and there may be data about it, the completed activity statistics flows into the information warehouse and will become available instantly. In different phrases, actual-time information warehousing is a framework for deriving statistics from data as the facts becomes available.
Oracle DBA Interview Questions
Question 12. What Is Data Mart?

Answer :

A information mart is a unique cause subset of organisation facts utilized by a specific branch, feature or application. Data marts may have each summary and information information, however, commonly the statistics has been pre aggregated or converted in a few way to higher deal with the specific sort of requests of a specific user community. Data marts are classified as impartial, logical and dependant statistics marts.

Oracle 10g Interview Questions
Question thirteen. How Do You Determine The Number Of Sessions?

Answer :

Teradata performance and workload.
Client platform kind, performance and workload.
Channel performance for channel connected systems.
Network topology and overall performance for community connected structures.
Volume of data to be processed via the application.
Oracle DBA Tutorial
Question 14. Syntax For Case When Statement?

Answer :

CASE value_expression_1 WHEN value_expression_n THEN scalar_expression_n

END;

Question 15. How To Find Duplicates In A Table?

Answer :

Group through those fields and pick out id, count(*) from desk organization by using identification having remember (*) > 1.

Oracle 11g Interview Questions
Question sixteen. While Creating Table My Dba Has Fallback Or No Fallback In His Ddl. What Is That?

Answer :

FALLBACK requests that a second reproduction of each row inserted into a table be saved on another AMP inside the identical cluster. This is performed while AMP goes down or disk fails.

Oracle 11g Tutorial
Question 17. There Is A Column With Date In It. If I Want To Get Just Month How It Can Be Done? Can I Use Sub String?

Answer :

Sub string is used with char fields. So it cannot be used. To extract month from a date column, ex pick extract (month from ). Same element for year or day. Or hour or mins if it’s a time stamp (select extract (minute from column call).

Hadoop Interview Questions
Question 18. Did You Write Stored Procedures In Teradata?

Answer :

No, due to the fact they grow to be a single amp operation and my company didn’t inspire that.

Informatica Interview Questions
Question 19. What Is The Opening Step In Basic Teradata Query Script?

Answer :

Logon tdipid/username, password.

Hadoop Tutorial
Question 20. How Do You Create A Table With An Existing Structure Of Another Table With Data And With No Data?

Answer :

Create table Customerdummy as Customer with facts / and not using a statistics

Database Administration Interview Questions
Question 21. What Is Basic Teradata Query Language?

Answer :

It allows us to write down SQL statements in conjunction with BTEQ commands. We can use BTEQ for importing, exporting and reporting functions.
The instructions begin with a (.) dot and may be terminated with the aid of using (;), it is not obligatory to apply (;).
BTEQ will anticipate any component written with out a dot as a SQL assertion and requires a (;) to terminate it.