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
- 13819 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you promote a non-reusable transformation to reusable transformation?
What is enterprise data warehousing?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain what is informatica metadata and where is it stored?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
where to store informatica rejected data?
Mention few power centre client applications with their basic purpose?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Can u generate reports in Informatica?
Can we get 1st record through Informatica(without sequence number).
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Why do you use Mapping Parameter and mapping variable?
