Interested to Buy Any Domain ? << Click Here >> for more details...
tell me the push down optimization
- 2 Answers
- 5846 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 meant by incremental aggregation?
what is the size of your data warehousing?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to convert flat file into xml file? How to tune joiner?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the new features in Informatica 5.0?
what is target load plan
sorce is a flatfile only 1st and last row should insert to target how will u do?
Teradata 
