What the difference is between a database, a data warehouse and a data mart?
No Answer is Posted For this Question
Be the First to Post Answer
In which transformation you cannot drag ports into it?
How to elaborate tracing level?
i have 2 session s1 execute s2 load first session fail what is the reason?
Design a mapping to load the cumulative sum of salaries of employees into target table?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
what is mean by throghput? in informatica
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
What is fact table? Explain the different kinds of facts.
Explain about Recovering sessions?
when will we go for unconnected lookup transformation in Informatica?