Interested to Buy Any Domain ? << Click Here >> for more details...
when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
- 1 Answers
- 4858 Views
- I also Faced
- E-Mail Answers
Answer / swapna
static cache is used when the records in the source does not update more frequently.
dynamic cache is used when the records in the source frequently updates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Whats there in global repository
Insert else update option in which situation we will use
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
What is a sequence generator transformation?
Difference between Target-based loading and constraint-based loading?
What is the fact table?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Enlist the differences between database and data warehouse.
Can we change Dynamic to Static or Persistent cache? If so what happens?
How do you load first and last records into target table?
What is the different lookup cache(s)?
Teradata 
