| Other Data Stage Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| I am defining one varaible parameter date in job
parameters.I want use this variable date in where clause in
source query. | TCS | 2 |
| What is lookup table? | | 3 |
| What modeling tool do you use? | HP | 5 |
| HOW CAN U DO ERROR HANDLING IN DATA STAGE? | ME | 5 |
| How did you reconcile source with target? | HP | 2 |
| 1)What is ur project architecture ?
2)how to move project from developement to uat?
3)What is the difference between datastage 6,7.1 and
datasttage 7.5?
4).How to do error handling in datastage?
5)3.Whta is unit testing, system testing and integration
testing?
6)What is the Exact difference between BASIC Transformer
and NORMAL Transformer?When we will go for BASIC Or NORMAL
Transformer
7)why we use third party tools in datastage?
8)What is the purpose of Debugging stages? In real time
Where we will use? | Wipro | 3 |
| How do u call shellscript/Batch file from DS? | HP | 3 |
| How do u set a default value to a column if the column value
is NULL? | HP | 5 |
| Why we need datasets ratherthan sequential files? | | 4 |
| what is the unix script to run the job?
Please mention commands which we use often? | TCS | 1 |
| wt is the difference between swith and filter stage | IBM | 2 |
| WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER? | Wipro | 2 |
| when we will use connected Lookup & Unconnected Lookup | Wipro | 1 |
| How do u view log file for a particular job? | HP | 3 |
| what is Audit table?Have u use audit table in ur project? | Wipro | 1 |
| How can we run same job in 1 day 2 times | IBM | 3 |
| Wat is isolation level and when do u use them? | HP | 1 |
| what is sparse lookup? | | 5 |
| What are the environmental settings for data stage,while
working on parellel jobs? | Satyam | 2 |
| can we use sequential file as a lookup | Wipro | 4 |
| |
| For more Data Stage Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
