How we will implement Pushdown Optimization and Types in Informatica with better examples
- 4 Answers
- 13232 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
Just to add on the above points.We cannot decide which
transofrmation logic to send to the Database.The
integrations service decides which login to send to the
database to optimize the process.although we can see the
sql logic in the Pushdown priview and the messages and
warning attached to it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is there any target staging area in informatica not staging area
What are the new features of Power Center 5.0?
How do you update the records with or without using update strategy?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is informatica metadata?
What is Index Caches size?
What all are steps in up gradation of Informatica server?
How can one identify whether mapping is correct or not without connecting session?
what is INFORMATICA TESTING process
Can you generate sequence numbers without using the sequence generator transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Performance tuning in UNIX for informatica mappings?
Define Pmrep command?
What is workflow manager?
4 yrs etl devloper roles and responsibilities?any body give solutions
