Interview question on loading

[Anonymous]

i come to know the interview question only on loading in qlikview for 2 years experience.

Thank You

[#2]

What do u meant by ?

u mean

type of loadswhere 2 years guy use ?

[Anonymous]

i know the types of load but dont know when ,why used it

so i come to know interview questions for 2 years on loading.

[HirisH_V7]

Check out this,

Different types of Loads in QlikView - TekSlate QlkView Tutorials

-Hirish

[Anonymous]

there is no interview question on loading

[HirisH_V7]

hello check out these too ,

Types of Load into QlikView

HTH,

Hirish

[Anonymous]

i need only interview questions

[Anil_Babu_Samineni]

May be they will ask many basic Questions such as

1) Concatenate Vs Join

2) What kind of data model you are using?

3) How you are capturing the Total sales value using Set Analysis.

4) So on

And especially, Coming to Type of loads they may ask like

5) What are the type of loads in qlikview

6) What was the use of Binary load

7) How do you create Island Table in qlikview with out any data source

HTH

[vinieme12]

instead of learning interview questions learn the tool and it's functions, simply remembering answers to interview questions won't help

You would most probably be given a task to accomplish, or a problem to solve in practical to demonstrate; so learning interview questions will never help until and unless you know what you are doing

[ramasaisaksoft]

Extension to Anil questions

• Explain Preceding Load and use of that .
• if the Drop table statement throwing error ,then what happens?(If you checked in script that table is available only)explain your observation
• they will give 2 tables and records count also and they will ask

1. if i use Join how many columns and rows count will come means output?
2. if i use Keep how many columns and rows count will come means output ?

           3. if i use Concatenate how many columns and rows count will come means output ?

           4. if i use Qualify/Un qualify how many columns and rows count will come means output ? ..etc

• If you have more no of Fact tables which schema you will follow? and how you will handle this situation?(Ex:-5 Fact tables and 20 Dimension tables)
• have you ever created Master calendar in your script ? ..etc