In which situations we can use normal and sparse lookup
stages
Answer Posted / poornachandrababu.l
When the reference is database then we will go for Sparse
look and If reference is Sequential file or DataSet then
we go for normal look up
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
If you want to use the same piece of code in different jobs, how will you achieve it?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How complex jobs are implemented in datstage to improve performance?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What could be a data source system?
options available in sequence job to run,validate?
Define Merge?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How to reverse the string using SQL?
How rejected rows are managed in datastage?
Highlight the main features of datastage?
What is datastage?
What are the features of datastage flow designer?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
table actions available in oracle connector?