Answer Posted / 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 |
Post New Answer View All Answers
Explain lookup transformation is active in informatica
State the limitations where we cannot use joiner in the mapping pipeline?
How to join three sources using joiner? Explain though mapping flow.
Can we get 1st record through Informatica(without sequence number).
How to partition the Session?
What are Dimensional table?
design of staging area?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is rank transformation in informatica
What is aggregate cache in aggregator transformation?
In warehouses how many schemas are there?
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?
Write the unconnected lookup syntax?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Write the unconnected lookup syntax and how to return more than one column.