Interested to Buy Any Domain ? << Click Here >> for more details...
How will you combine 3 different sources with a single source?
- 3 Answers
- 8660 Views
- I also Faced
- E-Mail Answers
Answer Posted / rkumar.etl
use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
what is INFORMATICA TESTING process
What is exclusive and normal mode for repository services?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are Dimensional table?
What is the way to execute pl/sql script using informatica mapping?
Explain informatica architecture - version 8 / 9
Clarify the aggregator change?
What is the sql query overwrite in source qualifier in informatica
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.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the informatica performance improvement tips
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
In how many ways we can create ports?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
