what is the use of Data Mart?
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
Data mart is a subset of data ware housing.it is a complete
information about one particular domain.
ex:finance,hr,sales.....
chandumba2005@gmail.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nagendra phani
Data Mart is the subset of datawahehouse and it is used to
store the data department wise.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sivaram
A DATA MART IS A SUB-SET OF AN ENTERPRRISE DATAWAREHOUSING.
A DATA MART IS ASUBJECT ORIENTED DATA BASE WHICH SUPPORTS THE
BUSINESS NEEDS OF INDIVIDUAL DEPARTMENTS WITHIN THE
ENTERPRISE.
A DATA MART IS ALSO KNOWN AS HIGH PERFORMENCE QUERY
STRUCTUERS.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / yash
data mart are specific ,repository of data, designed to
answer specific users.( examaple :sales)
| Is This Answer Correct ? | 0 Yes | 1 No |
What is fact table? Explain the different kinds of facts.
How do you migrate data from one environment to another?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
Repository user profiles
What are active and passive transformations?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,