Interested to Buy Any Domain ? << Click Here >> for more details...
what is work of PUSH DOWN option
- 2 Answers
- 7374 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 is the predefined port in dynamic lookup
How to load a Dimension ? and how to load a fact table?
How to jion 2 tables, without using any condition?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is row level and column level indicator?
How you prepared reports for OLAP?
connected and unconnected lookups?
Can you use flat files in Mapplets.
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
What are the Advantages of de normalized data?
Teradata 
