Interested to Buy Any Domain ? << Click Here >> for more details...
how to we create datamart?
- 2 Answers
- 8486 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaibhav bhandeo
Datamart is a subset of data warehouse and it supports a
particular region, business unit or business function.
Data warehouses and data marts are built on dimensional
data modeling where fact tables are connected with
dimension tables. It is designed for a particular line of
business, such as sales, marketing, or finance.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / amedela chandra sekhar
Data mart is a subset of Data warehouse.it is a complete information about one particular domain.eg:(finance,sales).
Data marts and Data warehouses are built on dimensional
data modeling where the relationship b/w dimension tables fact tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
What is the difference between Bitmap and Btree index?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Why update strategy and union transformations are active? Explain with examples.
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Can anyone tell me the new features in Informatica 9 Version?
How informatica recognizes mapping?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
Explain the different kinds of facts.
Enlist the tasks for which source qualifier transformation is used.
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
Teradata 
