Interested to Buy Any Domain ? << Click Here >> for more details...
Diffrence between static and dynamic cache
- 2 Answers
- 6306 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva prasad
Static cache: Is readonly cache. We cannot insert or update
the records dynamically.
Dynamic Cache: It will refresh the changed data and
allocate a seperate buffer for that.Each time it will
identify the changed data rather than capture entire
data.we can insert or update the records dynamically.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sushma
If you configure lookup TRFM to use dynamic cache, then u
can use only = operator in the lookup condition,whereas LKP
TRFM using static cache can use any relational operator in
the lookup condition.
| Is This Answer Correct ? | 1 Yes | 0 No |
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
Is it possible to update the target table with PK?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Whats there in global repository
How do you load alternate records into different tables through mapping flow?
how did u understand business requirement?
What are the associated ports in look up T/R.
Can we have a Mapping without a Source Qualifier?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
why u go for dimensions ?
Teradata 
