|
INTERVIEW QUESTIONS
DATA WAREHOUSING
DATASTAGE
DETAILS
Question: How can u implement slowly changed dimensions in datastage? explain?
2) can u join flat file and database in datastage?how?
Answer: Yes, we can do it in an indirect way. First create a job which can populate the data from database into a Sequencial file and name it as Seq_First1. Take the flat file which you are having and use a Merge Stage to join the two files. You have various join types in Merge Stage like Pure Inner Join, Left Outer Join, Right Outer Join etc., You can use any one of these which suits your requirements.
|
|
|
Category |
DataStage Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8396 users |
Added on |
7/26/2011 |
Views |
68232 |
Rate it! |
|
|
Question:
How can u implement slowly changed dimensions in datastage? explain?
2) can u join flat file and database in datastage?how?
Answer:
Yes, we can do it in an indirect way. First create a job which can populate the data from database into a Sequencial file and name it as Seq_First1. Take the flat file which you are having and use a Merge Stage to join the two files. You have various join types in Merge Stage like Pure Inner Join, Left Outer Join, Right Outer Join etc., You can use any one of these which suits your requirements. 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 |
|
How can you implement Complex Jobs in datastage
|
View Answer
|
|
Does Enterprise Edition only add the parallel processing for better performance?
Are any stages/transformations available in the enterprise edition only?
|
View Answer
|
|
How can you do incremental load in datastage?
|
View Answer
|
|
If your running 4 ways parallel and you have 10 stages on the canvas, how many processes does datastage create?
|
View Answer
|
|
If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?
|
View Answer
|
|
What is the difference between Datastage and Datastage TX?
|
View Answer
|
|
What are validations you perform after creating jobs in designer. What r the different type of errors u faced during loading and how u solve them
|
View Answer
|
|
How can I specify a filter command for processing data while defining sequential file output data?
|
View Answer
|
|
Can we use shared container as lookup in datastage server jobs?
|
View Answer
|
|
Can any one tell me how to extract data from more than 1 hetrogenious Sources. mean, example 1 sequenal file, Sybase , Oracle in a singale Job.
|
View Answer
|
|
What is the exact difference betwwen Join,Merge and Lookup Stage??
|
View Answer
|
|
There are three different types of user-created stages available for PX. What are they? Which would you use? What are the disadvantage for using each type?
|
View Answer
|
|
What user varibale activity when it used how it used !where it is used with real example
|
View Answer
|
|
DataStage from Staging to MDW is only running at 1 row per second! What do we do to remedy?
|
View Answer
|
|
What is the difference between datastage and informatica
|
View Answer
|
|
How is datastage 4.0 functionally different from the enterprise edition now?? what are the exact changes?
|
View Answer
|
|
What are orabulk and bcp stages?
|
View Answer
|
|
How to handle the rejected rows in datastage?
|
View Answer
|
|
It is possible to run parallel jobs in server jobs?
|
View Answer
|
|
What are the differences between the data stage 7.0 and 7.5 in server jobs?
|
View Answer
|