Hello Everyone, These are Some Interview Questions and some are scenario-based also so I need a good explanation of the questions below for my better understanding it would be a great help if Someone could guide me.
1. Types of load(Explain with examples)
2. Binary load(Explain with examples)
3. Incremental load (What are types of incremental load and what is the script of Append only, Insert only,Insert update, Insert update delete) with examples
4. Two data models are there and I want to bring that data into one application so how to do? (Binary load scenario)
5. One Data is already loaded and And I will write binary then the data which is loaded can I make any transformation changes in that data? (Binary)
6. Scenario of incremental load (where u have worked on )
7. Types of schema
8. Set analysis
9. If I have 10 products and have to show 3 products then how to do? (Set analysis scenario)
10. I have two tables and that is not linked so if I do selection eg. Today date is 13th so if I filter out the data then it should be get the date on selection basis. (Set analysis scenario)
11. Section Access (Has how many field)(with example)
12. What charts have you use
13. Which charts has no dimension
14. Which charts has no measure
15. There are 4 tables that have the same name what will happen if I load them.
