why do we need a datawarehouse when we have databases to store
data?
Answer / sriram
Database contains data called production data mostly and we can do operations but not recommended which is a performance issue and is always busy with application data
where as in DW,the data which we maitain is called historical data, on which we can play around.
Is This Answer Correct ? | 1 Yes | 0 No |
How do you get log info into a file?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
How one source columns or rows to be loaded in to two different tables?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
What is the command line function to import and export the ds jobs?
Where the datastage stored his repository?
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
What is the difference between lookup and sparse lookup?
How to add zero "0" before record in a field?
What is the difference b/w Hash file and Lookup Fileset stages?