why we need informatica
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / deepthi
etl's r of 2 types.code based n gui based.in code based etl
we have some limitations.inorder 2 over come those
limitations we use gui based etl ninformatica is 1 among
the gui.
Is This Answer Correct ? | 3 Yes | 2 No |
what is a time dimension? give an example?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is meant by a domain?
can you use flat file for lookup table?why?
what is runtime variable?
Explain the mapping variable usage example in informatica
explain about informatica server architecture?
What are differences between Informatica 7.1 and 6.1
What is flashback table ? Advance thanks
performance tuning of Informatica
What are the reusable transforamtions?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?