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 |
1.what is materialized data? 2.how to view the materialized data?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
WHAT are unix quentios in datastage
what is set mapping in datastage??
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
how can you generate sequence number using only the sequential file stage?
What are the functionalities of link partitioner?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
what is operator combinality in datastage?