can we use sequential file as a lookup
Answer Posted / chakravarthy kanishka
Look doesnt requires common key coloumn, then why we need key,
if we go for sequential file as a look up, and squential file have huge data,then it hits the performance,again you need to apply the performance techniques to the sequential file while reading the data,so better to avoid sequential file as a reference to look up.
its my guess...
please let me know if wrong.
thanks
kanishka
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is datastage engine?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the different plug-ins stages used in your projects?
How many types of sorting methods are available in datastage?
Define Routines and their types?
What are the components of datastage?
What are the types of hashed files in data stage
Can we use target hash file as a lookup ?
What is difference between join, merge and lookup stage?
What are the benefits of datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How to clean the datastage repository?
Give an idea of system variables.
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.