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|
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
WAT IS TEXT LOAD?
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?
What is the maplet?
Which is better performance wise database or file?How?
What is the need of building a data warehouse?
Write the different tools in the workflow manager?
HOW TO GET THE LATEST DATA IN SCD ?
What is a look up function? What is default transformation for the look up function?
What is mapplet in informatica?
how many types transformations supported by sortedinput?