why we r using presql&postsql in source qualifier?
Answer / amedela chandra sekhar
Presql :sql statement executed before the session retrive
the data from source.
Postsql:sql statement executed atfer the session retrive the
data from source.
| Is This Answer Correct ? | 10 Yes | 0 No |
How to load last n records of file into target table - informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to partition the Session?
wat are deployement groups in informatica, how it will be used for developers
Write the different tools in the workflow manager?
What is union transformation in informatica?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
What are the prerequisite tasks to achieve the session partition?
What is session task and command task?
Design a mapping to load the cumulative sum of salaries of employees into target table?
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.