How to fetch/retrieve the data from hieranchical database
and put it into the relational database?
for e.g I want to extract the data from IMS DB2 database
which is a hierarchical db and load that data into the
relational database which is a SQL server.Are there any
tools available for directing extracting data from
hierarchical db and loading into the relational database
(SQL server)?
What are different types of blocks used in stored procedure?
Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?
What is the purpose of TNS?
What is Data Modelling?
What is meant by distributed system?
Explain entity type?
What are the advantages of views in a database?
what is cardinality
What is the difference between specialization and generalization?
Is redis in memory database?
What is odm in database?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.