When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
Answer Posted / vinod saini
Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Enlist the various types of transformations.
difference between repository database and repository service?
What is informatica etl tool?
Explain load alternative records / rows into multiple targets - informatica
What are roles and groups and benefits of using them?
define galaxy repository in informatica
What do you mean by blocking transformation?
Write the prerequisite tasks to achieve the session partition?
What is dimensional table?
Enlist some properties of sessions.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Define Pmrep command?
What is blocking transformation?
How do you load first and last records into target table?
What is a rank transform?