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 |
How can we use mapping variables in informatica? Where do we use them?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
What is operational data source (ODS)?
Explain the use of aggregator cache file?
What is meta data and system catalog?
What are the Advantages of de normalized data?
What are Dimensions and various types of Dimensions?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?