tell me the push down optimization
- 2 Answers
- 5055 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagaraju
push down optimization is used increase the performance.in this concept integration service convert the transformation logic into query and send to the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / akhil4
this option available in session(work flow) properties.
it increase informatica server performance.
when ever u enable this option it created view in database related to logic.(MEANS YOU TAKEN SEVERAL T/R IN THIS U HAVE IMPLEMENTED LOGIC USING THAT LOGIC IT WILL CREATE A VIEW)
U START WF IT TAKE THE DATA DIRECTLY TO SQ AND PUSH DATA THROUGH LOGIC AND LODES INTO TARGET.
| Is This Answer Correct ? | 0 Yes | 3 No |
What is a configuration management?
What is native users?
What is CHECK-IN CHECK-OUT. Please explane me?
What is power play plug in?
Types of error logs in Informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can we use mapping variables in informatica?
How to update records in Target, without using Update Strategy?
what is data driven?
how can you load data into target table without leading zeor's
what is the exact meaning of domain?
How might you approve all mappings in the archive all the while?
Teradata 
