|
INTERVIEW QUESTIONS
DATA WAREHOUSING
DATASTAGE
DETAILS
Question: What are the Steps involved in development of a job in DataStage?
Answer: The steps required are:
select the datasource stage depending upon the sources for ex:flatfile,database, xml etc
select the required stages for transformation logic such as transformer,link collector,link partitioner, Aggregator, merge etc
select the final target stage where u want to load the data either it is datawatehouse, datamart, ODS,staging etc
|
|
|
Category |
DataStage Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 6812 users |
Added on |
7/26/2011 |
Views |
68436 |
Rate it! |
|
|
Question:
What are the Steps involved in development of a job in DataStage?
Answer:
The steps required are:
select the datasource stage depending upon the sources for ex:flatfile,database, xml etc
select the required stages for transformation logic such as transformer,link collector,link partitioner, Aggregator, merge etc
select the final target stage where u want to load the data either it is datawatehouse, datamart, ODS,staging etc Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Briefly describe the various client components?
|
View Answer
|
|
What is a project? Specify its various components?
|
View Answer
|
|
* What are constraints and derivation?
* Explain the process of taking backup in DataStage?
*What are the different types of lookups available in DataStage?
|
View Answer
|
|
Will the data stage consider the second constraint in the transformer once the first condition is satisfied ( if the link odering is given)
|
View Answer
|
|
How to remove duplicates in server job
|
View Answer
|
|
How do you do Usage analysis in datastage ?
|
View Answer
|
|
Purpose of using the key and difference between Surrogate keys and natural key
|
View Answer
|
|
What are the environment variables in datastage?give some examples?
|
View Answer
|
|
wht is the difference beteen validated ok and compiled in datastage.
|
View Answer
|
|
What is difference between Merge stage and Join stage?
|
View Answer
|
|
How to implement type2 slowly changing dimenstion in datastage? give me with example?
|
View Answer
|
|
How to find the number of rows in a sequential file?
|
View Answer
|
|
Where actually the flat files store?what is the path?
|
View Answer
|
|
What are the different types of lookups in datastage?
|
View Answer
|
|
What are the most important aspects that a beginner must consider doin his first DS project ?
|
View Answer
|
|
How we can call the routine in datastage job?explain with steps?
|
View Answer
|
|
What is job control?how it is developed?explain with steps?
|
View Answer
|
|
What is job control?how can it used explain with steps?
|
View Answer
|
|
How to find errors in job sequence?
|
View Answer
|
|
It is possible to access the same job two users at a time in datastage?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All DataStage Interview Questions & Answers - Exam Mode /
Learning Mode
|