How do you import and export data into datastage?
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
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you explain link buffering?
How you can fix the truncated data error in datastage?
What are the types of views in datastage director?
How and where you used hash file?
What are the various kinds of containers available in datastage?
How do you register plug-ins?
What are sequencers?
Why we use surrogate key?
Explain entity, attribute and relationship in datastage?
What is the difference between hashfile and sequential file?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How do y read Sequential file from job control?