tell me the push down optimization
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 time dimension? give an example?
what is the logic will you implement to load data into a fact table from n dimension tables?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
How can we improve session performance in aggregator transformation?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
how can we load starting with 11th record of a table from source to target
how the server recognises , if the session fails after loading the 100 records in to the target
How is Data Models Used in Practice?
What is the function of aggregator transformation?