| Other Data Stage Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain the functionality of your current project? | IBM | 1 |
| Explain the ChangeApply stage? | | 2 |
| wt is the diff b/w odbc and oracle stage | Accenture | 2 |
| Difference in the implementation of lookup and join
stages,in joining two tables? | TCS | 4 |
| what is the diff between sequential file and fileset stages?
| | 2 |
| at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it | IBM | 2 |
| 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 |
| How do u call shellscript/Batch file from DS? | HP | 3 |
| parallel jobs run on cluster machines.
server jobs run on smp and mpp.
What do mean by cluster mechines and SMP and MPP..?
| | 3 |
| what is the new version in Datastage ? what is the diff b/t
New vesion & 7.5 version? | Wipro | 7 |
| In aggregator stage,to find the sum of the entire group of
columns,it displays in binary format. How can i solve this
problem. | IBM | 1 |
| why we use hash file for lookup? | | 1 |
| WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER? | Wipro | 2 |
| hi,
how would i run job1 then job 3 , then job2 in a sequence of
job1 ,job2,job3.
Thanks
sunitha | CTS | 1 |
| what is combinability and non combinability? | | 1 |
| 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 is Audit table?Have u use audit table in ur project? | Wipro | 1 |
| 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 can we move a DATASTAGE JOB from Development to Testing
environment with the help of a datastage job using unix
commands. | | 2 |
| HOW CAN U DO ERROR HANDLING IN DATA STAGE? | ME | 5 |
| |
| For more Data Stage Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
