Interested to Buy Any Domain ? << Click Here >> for more details...
waht is dataware house
- 2 Answers
- 4682 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / somu
A Datawarehouse is a database.It has some Characteristics.Those characteristics database is known as Datawarehouse. these characteristics are subject oriented,time varint,non-volatile,integrated.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / azeez
A datahouse is subject oriented . combination of diffeent
datamarts
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the term PIPELINE in informatica ?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
where to store informatica rejected data? How to extract the informatica rejected data?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
What is the use of incremental aggregation?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
Why do you use Mapping Parameter and mapping variable?
How can you access the remote source into your session?
Can we override a native sql query within informatica?
How to eliminate 1st and last rows from the source and load the inbetween rows.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
Teradata 
