Interested to Buy Any Domain ? << Click Here >> for more details...
Diffrence between static and dynamic cache
- 2 Answers
- 6451 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 |
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
Repository user profiles
What is a shortcut and copy in Informatica and how two are different with each other?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
What is main use of mapplet?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
How do you remove duplicate records in informatica?
Do you find any difficulty while working with flat files as source and target?
how do the project develops? pls specify right from the start to end in step by steps.
Teradata 
