Answer Posted / ananda
Join: When volume of data is more than 10 million in both
source and reference link.
Sparse Lookup: When reference data is > 500 million and
source data is <10 million.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is the differentiate between data file and descriptor file?
What is the difference between operational data stage (ods) and data warehouse?
What is datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
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?
client know skid info?
Nls stands for what in datastage?
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 many types of views are there in a datastage director?
Where do the datastage jobs get stored?
What can we do with datastage director?
How many Key we can define in remove duplicate stage?