Answer Posted / mike
well informatica is the tool used for data aquisition
process..which is nothing but data extraction, data
transformation and data loading. Inorder to build a data
ware house we use informatica
or
It is a GUI tool and we need informatica for
running,designing,monitoring and administrating the data
flow from various external source and internal sources to
the data ware house
correct me if i was wrong
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
In how many ways we can create ports?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Explain dynamic target flat file name generation in informatica
What are the different types of repositories created using informatica?
What is the use of transformation?
What are the static cache and dynamic cache in informatica?
What is a difference between complete, stop and abort?
What are the settings that you use to configure the joiner transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Reusable transformation and shortcut differences
What is a snowflake schema?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are mapplets?
What is a pre-defined event and user-defined event?
