How we will implement Pushdown Optimization and Types in Informatica with better examples
- 4 Answers
- 12888 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 ? | 2 Yes | 0 No |
Answer / nsatyabrat7
Push Down Optimisation normally used for performance issue.
to use it u have to buy a separate license along with Informatica. As Sridhar tld there are 3 different kind of Push down optimisation which can be configured in session properties level.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Which is the t/r that builts only single cache memory?
how we load the data from source to staging area
Clarify the aggregator change?
What is the difference between procedure and stored procedur?
Explain pushdown optimization and types in informatica
wht is cdc?how to use it in creation of mappings?
Target is zero file and how can you send the email?
Is snow flake or star schema used? If star schema means why?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
What is a configuration management?
Teradata 
