How can you define a transformation? What are different types of transformations in Informatica?
TCS,
7 10812Post New Data Warehouse General Questions
How can you set the client management?
How to load the time dimension?
Tell me what is degree of a relation?
Can decision tree be implemented using SQL?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
what are relationships?
What are algorithms provided by Microsoft in SQL Server?
what are the other factors of the database on which the loading performance depend?
What is static and local variable?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain er diagram?
How do we design a universe?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain what is the difference between a primary and secondary actor in use case modeling?
What is dimensional modelling?