what is work of PUSH DOWN option
Answers were Sorted based on User's Feedback
Answer / 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 |
The Pushdown Optimization Option improves performance by
enabling processing to be “pushed down” to a
relational database, maximizing fl exibility, minimizing
unnecessary data movement, and providing the optimal
performance for both data-intensive and process-intensive
transformations.
| Is This Answer Correct ? | 2 Yes | 0 No |
Can you generate sequence numbers without using the sequence generator transformation?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
Explain load alternative records / rows into multiple targets - informatica
Define the various join types of joiner transformation?
What is a poling?
Explain the difference between a data warehouse and a data mart?
Briefly define reusable transformation?
What is up date strategy and what are the options for update strategy?
How do you load alternate records into different tables through mapping flow?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
what is Active lock explain