In which scenario did you used pushdown optimization?
Answer / tamilarasan
when the source and target are database we can use the pdo.
| Is This Answer Correct ? | 0 Yes | 0 No |
How will you combine 3 different sources with a single source?
what is the diff b/w cached and unchaed look ups
What is workflow monitor?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Briefly describe lookup transformation?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
What does update strategy mean, and what are the different option of it?
How to view and Generate Metadata Reports?
What are different types of transformations available in informatica?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?