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 |
What is a joiner transformation and why it is an active one?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
What is an unconnected transformation?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
How to fix the etl bugs..Tell me the process?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
Explain the informatica workflow?
Why sorter is an active transformation?
Describe two levels in which update strategy transformation sets?
how can we check whether a particular cache is static or dynamic?
what is diff between grep and find
What is a transaction control transformation?