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

Scheduling properties,whats the default (sequential)

1895


What are the differences between oltp and olap?

923


What are the various types of transformation?

1097


Explain lookup transformation in informatica

1007


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1204


Explain about cumulative Sum or moving sum?

983


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2142


How to load data in informatica ?

955


I have a flat file, want to reverse the contents of the flat file

1068


How you know when to use a static cache and dynamic cache in lookup transformation?

1795


How to join three sources using joiner? Explain though mapping flow.

1092


Write the advantages of partitioning a session?

1209


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1807


How can informatica be used for an organization?

1135


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1997