| Other Data Stage Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How did you reconcile source with target? | HP | 3 |
| Hi Gus,
Can u pls tell me
How can u Call the Shell Scripting/Unix Commands in Job
Sequence? | IBM | 1 |
| Why we need datasets ratherthan sequential files? | | 4 |
| How do u set a default value to a column if the column value
is NULL? | HP | 5 |
| wt is the difference between swith and filter stage | IBM | 2 |
| WHAT are unix quentios in datastage | TCS | 1 |
| Tell me Wt main advantage of Stage varibles?
Project level hints? | Hexaware | 3 |
| Hi am sundar, i have datas like
00023-1010
00086-1010
00184F2-1010
.
.
.
.
SCH-AS-1010
200-0196-039
.
.
.
Now i want the result as values before the delimiter should
come under the column ITEM_CODE and values after the
delimiter should come under the column LOC_CODE.. But some
datas like "SCH-AS-1010", for this, "SCHAS" should come
under the column ITEM_CODE and 1010 should come under the
column LOC_CODE.. Pls help me.. | | 1 |
| WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD | L&T | 2 |
| HOW TO CREATE ENVIRONMENTS AND CALL THEM?WHAT IS THE USE
DEFINED VARIABELS? | ME | 1 |
| Hi Vijay here
For Four CPU's how many nodes will required?
| TCS | 2 |
| WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER? | Wipro | 2 |
| wt is the diff b/w odbc and oracle stage | Accenture | 2 |
| what is datastage job Monitoring | CTS | 2 |
| Hi I have scenario like this
s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000
How can i get target table like that without using
Transformer stage? | Semantic-Space | 1 |
| tell me abt Datastage trigger? | HP | 1 |
| 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 |
| what is the difference between the active datawarehouse
and datawarehouse | TCS | 1 |
| in a job of 20 one job is very slow due to that entire job
is slow how can u find out which job is slow? | IBM | 1 |
| what is the main differences between Lookup, Join and Merge
stages? | | 4 |
| |
| For more Data Stage Interview Questions Click Here |