Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / satya
In addition to Kapil's answer, You can have "push down"
optimization at source database or target database or Full
(Source and target). But before you enable this option you
keep the following things in mind
1. When you are processing long transaction at database
level , The objects will be lock and data base objects are
not available for other operations for long time.
2. It will inturn hampers the datbase concurrency and
increases the chance of "Dead locks" on database
Thanks : Satya
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is incremental aggregation?
Performance tuning in UNIX for informatica mappings?
How to load the data from a flat file into the target where the source flat file name changes daily?
What could be the possible resons of locks by user?
what is INFORMATICA TESTING process
What do you mean by filter transformation?
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 ?
How to improve the performance of a session using sorter transformation?
Differentiate between router and filter transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the differences between joiner transformation and source qualifier transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are session parameters ? How do you set them?
Explain sessions. Explain how batches are used to combine executions?
What are different types of transformations available in informatica?
