why we need informatica

Answers were Sorted based on User's Feedback



why we need informatica..

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

why we need informatica..

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

Post New Answer

More Informatica Interview Questions

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,


How to do the error handling of if ur source is flatfiles?

0 Answers  


i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,


How to elaborate powercenter integration service?

0 Answers  






Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


What is informatica? What exactly are the practical uses in real world

2 Answers  


my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,


What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,


What is the difference between informatica 7.0 and 8.0?

0 Answers  


What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,


What are the join types in joiner transformation?

1 Answers   Informatica,


Categories