Attributes of data stage
List out the main attributes of the data stage?
Expert
Data Stage has following features to assist the design and processing the required in order to build the data warehouse:
a) Uses the graphical design tools. Along with the simple point and click the techniques you may draw the scheme in order to present your processing requirements.
b) Extract the data from any number or types of the database.
c) Manage all the definitions of the metadata needed in order to describe your data warehouse. You may view and alter the table definitions at any point during the design of your application.
d) Aggregates data. You may alter the SQL SELECT statements which are used in order to extract the data.
e) Transforms data. Data Stage consists of the set of predefined transforms and functions you may use in order to transform your data. You may also easily increase the functionality by describing your own transforms to use.
Elucidate how can we get first 100 rows from flat file in the target?
Explain the term queue in data structure? Answer: In data structure a queue is a sequential organization of data. It is a first in first out i.e. FIFO type of data s
Cloud Computing – A computing capability that provides an abstraction between the computing resource and its underlying technical architecture (e.g., servers, storage, networks), allowing convenient, on-demand network access to a shared pool of
Write down a short note on the Volatile Temporary tables (VTT).
Explain some of the data mining tools.
Clarify briefly why dimension tables is de-normalized in the nature?
Explain how teradata ensures that there are no duplicate rows being inserted when it’s a SET table?
Give brief introduction of the term an OLAP system and OLTP system?
Write a brief note on the difference between data and database administration?
18,76,764
1945302 Asked
3,689
Active Tutors
1427907
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!