ETL_Datastage_考试.doc

DATASTAGE % of tracing in ETL 0.02 0.04 0.05 0 What is the default run connection timed out in data stage? 86400 sec 10000 never 84600 Which of the following database is used in DS repository? Universe Oracle Sybase Ms SQL server Sequential file is a passive stage In a hashed file, if u add a duplicate column to a key column (only one column) First record is retained Last record is retained All duplicates are inserted None DS activities Compile jobs or validate and then run jobs Where can we view the elapsed time? DS Director Data Stage is a? ETL tool Reporting Tool Metadata Tool ETL stands for – Extraction Transformation and Loading Which client tool is used to Schedule, Run and validate the Job? DS Director For ODBC connection to be established DSN to be specified in client DSN to be specified in client and server DSN not necessary DSN Should be created in server Data Cache Size will be specified in DS Admin DS Designer DS Manager Data stage components can be imported into or exported from DS manager-True or false. True How will a default user be notified while login in DS administrator DS admin Sys admin Root none Which client tool is used to create or move projects? DS designer DS director DS manager DS administrator Data stage job consist of links stages none of the listed options Both links and stages A fact table in the centre surrounded by dimension tables which are again split up into further dimension tables is called as Star schema Snowflake schema None In DS, a job cannot be run if it is in the Stopped state Not compiled state Validated state None When a job is added to a hashed file, then the file quicker also gets added (True/False) True No of input links for a transformer 1 streamed input link 1 input link Same as that of the output links Aggregator is an active stage Transformer can be created without an input link. True/ False True Which of the following is correct? constraints( derivations ( stage variables derivations ( stage variabl