how would u estimate the size of Lookup transform data and
index cache?
- 1 Answers
- 2230 Views
- I also Faced
- E-Mail Answers
Answer / Shwet Prakash
To estimate the size of Lookup transform data, you can check the source table's size or total rows. For the index cache, it's dynamically allocated based on the number of unique values in the lookup key column and their corresponding data types. You can calculate an approximate size by counting the unique values and considering their respective data type sizes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain me ETL project architecture in Detail?
Explain about etl data integration software?
What are the different etl testing categories as per their function?
What is the difference between project backlog and product backlog?
what is SMP AND MPP?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is a staging area? What is the purpose of a staging area?
dimension object created in oracle can be imported in designer?how?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Explain etl?
When do we analyze the tables?
Teradata 
