| Other Data Stage Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| which memory is used by lookup and join |
IBM | 4 |
| why we use hash file for lookup? |
| 5 |
| How to generate surrogate key without using surrogate key stage? |
IBM | 4 |
| CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR
NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY? |
| 2 |
| what is mapping lookup |
| 1 |
| can explain wt is the pool for file. |
CTS | 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 |
| In merge stage can we update the values? |
TCS | 3 |
| 1.How to read multiple file from sequential stage.
2.If a file doesn't arrive or doesn't exists in sequential
stage how do u handle this.
3.What do you do before taking data from source to staging
area.
4. I have a remove duplicate stage and transformer
stage.what will u do for optimizeing the performance of the
job. |
Syntel | 4 |
| 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 |
| what is factless fact table? |
IBM | 3 |
| Hi This is Vijay
How Can u Read the data from sequential file Parall'y? |
Semantic-Space | 5 |
| |
| For more Data Stage Interview Questions Click Here |