Interested to Buy Any Domain ? << Click Here >> for more details...
what is datamart
- 4 Answers
- 7890 Views
- IBM, Informatica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
Data Mart is subset of enterprise datawarehouse which
supports bussiness needs of middle level management in an
enterprise.
datamart is designed for particular line of business,such
as sales,marketing and finance
DW is maitaining the total organization of data
where as DM is maitained only particular subject.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / sujana
data mart is a particularsubject unlike dwh..for ex
totla organization data --dwh
sales,marketing etc--data mart
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / tom
Adding to Sunil's answer- Data Mart is a object oriented and
DW is a subject oriented
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vali
hi guys iam adding one more point...
data mart is designed for business transcational process
where as dwh desgined for business analysys
any modifications plz let me kw..vali
vali413@gmail.com
| Is This Answer Correct ? | 0 Yes | 4 No |
What is session task and command task?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Please let me know how to make encryption and decryption with example?
What is lookup change?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the default source option for update stratgey transformation?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to delete first 3 rows & last 3 rows in target table in informatica
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!!
Teradata 
