How do you create Surrogate Key using Ab Initio?
Submitted by: AdministratorThere are many ways to create Surrogate key but it depends on your business logic. Here you can try these ways.1. Use next in sequence () function in your transform
2. Use Assign key values component (if your GDE is higher than 1.10)
3. Write a stored proc to this and call this store proc wherever you need.Yes, dimension table contains numeric but not contain measures and facts
Submitted by: Administrator
2. Use Assign key values component (if your GDE is higher than 1.10)
3. Write a stored proc to this and call this store proc wherever you need.Yes, dimension table contains numeric but not contain measures and facts
Submitted by: Administrator
Read Online Data Warehousing Job Interview Questions And Answers
Top Data Warehousing Questions
☺ | What is the difference between aggregate table and materialized view? |
☺ | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |
☺ | What is the advantages data mining over traditional approaches? |
☺ | What are data validation strategies for data mart validation after loading process? |
☺ | Can you pass sql queries in filter transformation? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |