Answer Posted / 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 |
Post New Answer View All Answers
How to handle decimal places while importing a flatfile into informatica?
What are pre and post-session shell commands?
In development project what is the process to follow for an etl developer from day1
Write the unconnected lookup syntax and how to return more than one column.
What does cheating measurement mean?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Is there any way to read the ms excel datas directly into informatica?
What is the sql query overwrite in source qualifier in informatica
Enlist few areas or real-time situations where informatica is required.
What are batches?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to partition the Session?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
can u give example for factless fact table
Can you generate sequence numbers without using the sequence generator transformation?