Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Relationships among data

"Given a data set, determine how the relationships among data will affect the QlikView data model (e.g., performance, accuracy)"

What this mean in qlikview certification.

experts please give me some sample, what they expect

1 Reply
Gysbert_Wassenaar

What this mean in qlikview certification.

It means you have to answer the question correctly or you won't get the points for it.

You have to understand why different actions have different effects on your data model with respect to performance, accuracy etc.

What happens when you join tables? Are there alternatives to joining tables? When would you use them? Why?

What is a synthetic key? Why is it created? Is it a problem? How can you prevent a synthetic key?

What is a cyclic reference? Why is it created? Is it a problem? How can you prevent it?

What is a slowly changing dimension? How can you handle a SCD in the model? What are the alternatives? Why would you choose one over the other?

When do you choose to concatenate tables? Why? What are the alternatives? What are the trade offs between them?

When would you use a Link table? Why? What are the alternatives?

...

etc


talk is cheap, supply exceeds demand