Explain Datastage
Define the term DataStage?
Expert
a) Develop jobs for the purpose of Extraction, Transformation and Loading (ETL).
b) Ideal tool data integration projects like the data marts, data warehouses and system migrations.
c) Import, export, generate and maintain the metadata for use within the jobs.
d) Schedule, run and monitor the jobs all inside Data Stage
e) Administers your Data stage development and the execution environments.
Explain about the stored-procedures and its advantages.
List out the different types of the data providers?
Illustrate the main merits of employing stored procedures?
define types of transaction failures and also what is meant by catastrophic failure?
Explain the transformations which are used for the variable port?
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Explain the term iConv and oConv?
Give a brief introduction of the term dicing and slicing in business objects?
What are the drawbacks of the client or server model?
Elucidate briefly what is batch and also give explanation about the types of batches?
18,76,764
1954955 Asked
3,689
Active Tutors
1421535
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!