what is pre and post sql and what is diff between source
presql and target pre sql
Answer / priyaraj
Pre SQL means that the integration service runs SQL
commands against the source database before it reads the
data from source.
Post SQL means IS runs SQL commands against target database
after it writes to the target.
Is This Answer Correct ? | 26 Yes | 3 No |
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a command that used to run a batch?
explain about session partitions ?
What is data caches/ index caches?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain about Informatica server process that how it works relates to mapping variables?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
Define maping and sessions?
How to eliminate duplicate records in informatica mapping? Explain with an example....
What is DTM process?
what is worklet and what use of worklet and in which situation we can use it?
How to go to the older version for a mapping?