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
Differentiate between datastage and datastage tx?
How can you write parallel routines in datastage PX?
What is the difference between Datastage 7.5 and 7.0?
what is use of SDR function?
What are the some differences between 7.x and 8.x version of datastage?
how many rows sorted in sort stage by default in server jobs
How do you import and export the datastage jobs?
What is the sortmerge collector?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the difference between orabulk and bcp stages?
What are routines in datastage? Enlist various types of routines.
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Can you explain players in datastage?
what is the use of materialized view?