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
- 14027 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
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?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How big was your fact table
What do think which one is the better joiner or look up?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is meant by lookup transformation?
Enlist some properties of sessions.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Define the various join types of joiner transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How can we store previous session logs?
Which are the different editions of informatica powercenter that are available?
