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.
States the term Global temporary.
Specify the 2 modes of data movement in the Informatica Server?
Illustrates the term data sparsity and how this effect upon aggregation?
Explain about the stored-procedures and its advantages.
Provide a brief introduction on the term ‘cube grouping’?
Explain about Server Job and Parallel Jobs?
Describe briefly Aggregate transformation?
Explain the security aspects of stored procedures.
Elucidate how many kinds of dimensions are accessible in the Informatica?
How would the developer describe variable by using referential data types?
18,76,764
1942830 Asked
3,689
Active Tutors
1416177
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!