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 are challenges that you faced in testing? give solution to it?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How the facts will be loaded? explain
What are roles and groups and benefits of using them?
In a sequential batch can u run the session if previous session fails?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
How Union Transformation is an Active Trans?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
Differentiate between joiner and lookup transformation?
Why do we need informatica?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?