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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

tell me the push down optimization

Question Posted / anu63.p

Answers were Sorted based on User's Feedback



tell me the push down optimization..

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

tell me the push down optimization..

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

Post New Answer

More Informatica Interview Questions

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

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

0 Answers  

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

What are the different types of schemas?

11 Answers   ITC Infotech,

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

What is a pre-defined event and user-defined event?

0 Answers  

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

Explain the etl program with few examples.

0 Answers  

For more Informatica Interview Questions Click Here
Categories