Interested to Buy Any Domain ? << Click Here >> for more details...
tell me the datawarehouse defination,and it is maintaing
hystorical data meaning,what is the use
- 1 Answers
- 3750 Views
- I also Faced
- E-Mail Answers
Answer / abhinaw prakash
Data warehouse is the coordinated,periodic copying of data
from different sources both inside and outside the
enterprise into an environment optimized for analytical and
informational processing.
By Historical data means that historical data will also be
kept along with the most recent data unlike the OLTP system.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain in detail about scd type 1 through mapping.
waht is dataware house
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
Enlist the tasks for which source qualifier transformation is used.
What is the sql query overwrite in source qualifier in informatica
What is difference between a connected look up and unconnected look up?
What is a transaction control transformation?
What is polling in informatica ?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
Differnce between filter and router?
Teradata 
