how to through logic of informatica using the push down
optimization into oracle.
Answer Posted / venubyna1
Asession configure for push down optimization to Increase
the session performance.
The I.S Analyze the mapping and T/r logic and determine T/r
logic it ll send to the source or Tager data base
I.S is convert the T/r logic into SQL then send to the data
base server
there r 3 types
1. Source side push down
2.Target side push down
3.fullside push down
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
In warehouses how many schemas are there?
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
how many types of dimensions are available in informatica?
Performance tuning( what you did in performance tuning)
How to update source definition?
What is a passive transformation?
What is workflow? What are the components of workflow manager?
In which transformation you cannot drag ports into it?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain your project of banking domian.
What is meant by lookup transformation?
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
Please let me know how to make encryption and decryption with example?