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 a router transformation?

0 Answers  


Differentiate between router and filter transformation?

0 Answers  


Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  


What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  






There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,


How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,


Informatica and datawarehousing courses in Pune?

2 Answers  


two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,


What is Java Transformation? what are the uses of it?

0 Answers   TCS,


I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,


what are 3 tech challenges/ common issues you face?

0 Answers   TCS,


Categories