Answer Posted / varma
Hash files is the only way to do lookup .. It is key based
and ensures no duplicates are present on that key. It wont
give an error if you use OCI or DB2 stage as lookup but the
results will be wrong...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are datastage sequences?
Define Merge?
Define Job control?
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
Explain entity, attribute and relationship in datastage?
What all the types of jobs you developed?
What is difference between join, merge and lookup stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
project Steps,hits, Project level HArd things,Solved methods?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the stages in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
what is ds administrator used for?
What are constraints and derivations?