Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

tell me the push down optimization

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we store previous session logs?

1132


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2079


what is $$$$?

2200


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2066


Explain transaction control transformation in informatica

1307


What is a mapplet/worklet in informatica?

1241


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1945


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8256


Separate from a database, an information bazaar, and an information stockroom?

1126


What are the new features of informatica 9.x in developer level?

1052


lookup transformation with screenshots

4045


What is the session task and command task?

1110


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2184


What is a sorter transformation?

1151


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1135