wt is the diff b/w odbc and oracle stage
- 2 Answers
- 18752 Views
- Accenture, HCL, I also Faced
- E-Mail Answers
Answer Posted / bi etl
ODBC Stage require few connectivites to connect where are
Oracle just we can connect with server details.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define Data Stage?
What is meta stage?
Describe the architecture of datastage?
Define project in datastage?
What are the repository tables in datastage?
What is the purpose of interprocessor stage in server jobs?
What are the different types of lookups in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What steps should be taken to improve Datastage jobs?
What is the use of hoursfromtime() function in transformer stage in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are constraints and derivations?
EXPLAIN SCD
What all the types of jobs you developed?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
