what is work of PUSH DOWN option
- 2 Answers
- 6207 Views
- Wipro, I also Faced
- E-Mail Answers
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 will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
What is a configuration management?
What are the unsupported repository objects for a mapplet?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
Define mapplet?
How will you convert rows into columns or columns into rows
Can I create one wrkflw which will run different wrkflws on schedule time?
What are the disadvantages of Sequence Generator T/R?
What is Index Caches size?
Under which circumstances, informatica server creates reject files?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
Teradata 
