Interested to Buy Any Domain ? << Click Here >> for more details...
How we will implement Pushdown Optimization and Types in Informatica with better examples
- 4 Answers
- 13985 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is workflow monitor?
Explain in detail scd type 2 through mapping.
How will the document be delivered to me?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
is it possible to index the data in cache of lkp transformation ?
What is option by which we can run all the sessions in a batch simultaneously?
What are the types of schemas we have in data warehouse and what are the difference between them?
During the running session, output files are created by informatica server. Enlist few of them.
Explain sessions and how many types of sessions are there?
What do you mean by enterprise data warehousing?
Explain joiner transformation in informatica
Please let me know how to make Data masking in informatica..
can we override a native sql query within informatica? Where do we do it? How do we do it?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
In which transformation you cannot drag ports into it?
