|
Related Questions |
View Answer |
|
What is the default cache size? How do you change the cache size if needed?
|
View Answer
|
|
What are Stage Variables, Derivations and Constants?
|
View Answer
|
|
What is the flow of loading data into fact & dimensional tables?
|
View Answer
|
|
Dimension Modelling types along with their significance
|
View Answer
|
|
Differentiate Database data and Data warehouse data?
|
View Answer
|
|
What are the difficulties faced in using DataStage ? or what are the constraints in using DataStage ?
|
View Answer
|
|
What is the order of execution done internally in the transformer with the stage editor having input links on the lft hand side and output links?
|
View Answer
|
|
How do you track performance statistics and enhance it?
|
View Answer
|
|
What is SQL tuning? how do you do it ?
|
View Answer
|
|
What happens if the job fails at night?
|
View Answer
|
|
How do you pass the parameter to the job sequence if the job is running at night?
|
View Answer
|
|
How do you populate source files?
|
View Answer
|
|
Suppose if there are million records did you use OCI? if not then what stage do you prefer?
|
View Answer
|
|
Why do you use SQL LOADER or OCI STAGE?
|
View Answer
|
|
What r XML files and how do you read data from XML files and what stage to be used?
|
View Answer
|
|
How many jobs have you created in your last project?
|
View Answer
|
|
Tell me the environment in your last projects
|
View Answer
|
|
Did you Parameterize the job or hard-coded the values in the jobs?
|
View Answer
|
|
What is Hash file stage and what is it used for?
|
View Answer
|
|
What are Static Hash files and Dynamic Hash files?
|
View Answer
|