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.
Write down the differentiation between lookup and filter transformation?
Illustrate the different Types of facts?
What does web mining mean
Clarify briefly why dimension tables is de-normalized in the nature?
Describe a surrogate key and also explain the ideal primary key and illustrate how surrogate keys meet up this ideal?
Specify the 2 modes of data movement in the Informatica Server?
Illustrates a stored procedure?
Describe briefly three types of binary relationships in DBMS?
What do you mean by the term stored procedure in the Teradata?
18,76,764
1923230 Asked
3,689
Active Tutors
1422989
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!