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 to enter same record twice in the target table,explain?
What are the tasks that Loadmanger process will do?
what is the mechanism of the Master-Detail joining condition?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Enlist the advantages of informatica.
How to load the data from a flat file into the target where the source flat file name changes daily?
If we have lookup table in workflow how do you trouble shhot to increase performance?
what are the perameter and variable?
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
who is the best faculty for informatica in hyderabad ameerpet?