Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ramya
use sparse lookup when reference database is huge i.e ratio
of input data and reference data is 1:100 or more
| Is This Answer Correct ? | 37 Yes | 7 No |
Post New Answer View All Answers
What is the difference between operational data stage (ods) and data warehouse?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
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)
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How many types of stage?
How a routine is called in datastage job?
how can we create rank using datastage?what is the meaning of rank?
Can you filter data in hashed file?
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)
Is possible to create skid in dim,fact tables?
What are the processing stages?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the use of datastage director?
What is the difference between orabulk and bcp stages?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
