| Other Data Stage Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How can u execute the sql query through unix?
What is the Primary key for Dimension table?
what is the primary key for Fact table? | TCS | 1 |
| when we will use connected Lookup & Unconnected Lookup | Wipro | 1 |
| What is exact difference between Parallel Jobs and server Jobs.. | IBM | 6 |
| how can i abort the job if i get more than 100 errors in
job log? | Accenture | 3 |
| what is the definitions for Datawarehose and Datamart?
| | 3 |
| How did you reconcile source with target? | HP | 3 |
| LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS? | ME | 2 |
| What's the Main Function of the Staging area in DWH | Oracle | 1 |
| what is Audit table?Have u use audit table in ur project? | Wipro | 1 |
| can we use sequential file as a lookup | Wipro | 4 |
| What modeling tool do you use? | HP | 5 |
| How can we run same job in 1 day 2 times | IBM | 3 |
| what is the main differences between Lookup, Join and Merge
stages? | | 4 |
| what is sparse lookup? | | 5 |
| Explain the ChangeApply stage? | | 2 |
| when will you go for dataset and fileset? | Accenture | 2 |
| WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD | L&T | 2 |
| if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs...srinu.thadi | IBM | 10 |
| How much data u can get every day?
2)which data ur project contains?
3) what is the source in ur project?what is the biggest
table & size in ur schema or in ur project? | Wipro | 2 |
| How to create user defined environment varibale(parameter)? | TCS | 1 |
| |
| For more Data Stage Interview Questions Click Here |