Need Ans for the foll. Interview Questions faced during Project Interview.

[Anonymous]

Hi All,

I have 1.6+ years of Exp in QV 11.2. I'm, giving interviews for the Internal projects. Below are the few questions that I faced during Interview and need to have their answers. Kindly help please.

1. Non-Optimized Load and Duration time

Situation 1: Plain Extraction and Apply Map

Situation 2: Resident Load on Extracted QVD and then Apply Map

Situation 3: Preceding Load and Apply Map

From above 3 situations,  rank in order on the basis of fastest, faster, fast load and why?

2. Straight Table has a few Ds and Es that shows Currency as $USD. With the list box provided that has option it to change to Pound and INR then how the selection must change the values in Straight Table to the selected Currency?

3. Dashboard is in English and now if the list box is provided that has values Spanish, Japanese and etc then how the complete dashboard will change its language?

4. How to color the alternate rows of the Straight Table having 5 Ds and 3 Es?

5. Initial Data reduction based on Section Access is checked and Strict exclusion is unchecked, what will happen?

6. Is it mandatory to write the Section Access code in Hidden script? If so, why?

7. What is "Section Application" in the section access code?

8. Have 1 QVD that has data for Q3-2017 and Q4-2017. Now, I have to append the data for Q1-2018 and remove Q3-2017 data in the same QVD using Incremental Load.

Also, do let me know where can I get such scenario based questions to study?

Thank you so much in advance. Eagerly waiting for the answers to pen down.

[Peter_Cammaert]

Isn't that ... cheating?

[shiveshsingh]

1. Non-Optimized Load and Duration time

Situation 1: Plain Extraction and Apply Map

Situation 2: Resident Load on Extracted QVD and then Apply Map

Situation 3: Preceding Load and Apply Map

From above 3 situations,  rank in order on the basis of fastest, faster, fast load and why?

Situation 3, Situation2, situation 1  in order of decreasing ( fast)

preceding load will take only one turn to load the data

Resident will first load the original data and then resident load

extraction from source is slow in compare to these loads

[shiveshsingh]

Straight Table has a few Ds and Es that shows Currency as $USD. With the list box provided that has option it to change to Pound and INR then how the selection must change the values in Straight Table to the selected Currency?

For this, you need to format your expression output so tat it starts giving desired value

num(Expression_output,vFormat)

Now define the vFormat like below.

=if([List Box Value]='X','$#,##0','#,##0')

[shiveshsingh]

3. Dashboard is in English and now if the list box is provided that has values Spanish, Japanese and etc then how the complete dashboard will change its language?

You need to create language Variables for this.(translation files will be required)

[shiveshsingh]

Have 1 QVD that has data for Q3-2017 and Q4-2017. Now, I have to append the data for Q1-2018 and remove Q3-2017 data in the same QVD using Incremental Load.

This can be done through Where exists function, i guess

[shiveshsingh]

5. Initial Data reduction based on Section Access is checked and Strict exclusion is unchecked, what will happen?

6. Is it mandatory to write the Section Access code in Hidden script? If so, why?

7. What is "Section Application" in the section access code?

You can easily get answers of these questions in the community itself, please do some research

[shiveshsingh]

4. How to color the alternate rows of the Straight Table having 5 Ds and 3 Es?

=if(Even(RowNo(TOTAL)), Put colour)

This will put color in alternate row.

[Anonymous]

Hi Peter,

Apology if u feel so but these were the questions I already faced just needed to tally it with my ans if I was correct or not as the Interviewer didn't said neither correct nor wrong. Thanks.

[Anonymous]

Thanks Shivesh for solving almost all questions.

1. But if I'm not wrong Resident load takes more time than plain extraction because u load ur 1st QVD, apply transformation using resident load (means same QVD loading twice + Applymap) please correct me if I'm wrong.

My ans was : 1. Preceding (fastest) 2. Plain Extraction (faster) 3. Resident

2. For the Quarter data using Incremental load.. We need to use all the 3 concepts right: Insert, Update, Delete?

3. Language variable means: can u put some light on this to change the language.

4. For the Currency conversion, its not just the sign we need to think we need the Rs. to be converted into Pounds or USD or vice versa.