what is the diff b/w cached and unchaed look ups
Answer Posted / sujana
if v cache the lukup..IS queries the cache for each row dat
eneters
if v dont cache IS queries the database for each row dat
enters..i.e issues a slect statemnt for each row
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
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 ?
Define Pmrep command?
what is $$$$?
How can you generate reports in informatica?
What is informatica powercenter repository?
Does an informatica transformation support only aggregate expressions?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are active and passive transformations?
What is dimensional table?
How to elaborate tracing level?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Define mapplet?
Differentiate between sessions and batches?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.