What are session timeout and application timeout? Where we have to do this process?
No Answer is Posted For this Question
Be the First to Post Answer
What is data validation strategies for data mart v?
Explain how to get the first 100 rows from the flat file into the target?
List any five applications of data warehouse.
What is the main difference between star and snowflake star schema? Which one is better and why?
Why fact table is in a normal form?
What is the use of incremental aggregation? Explain me in brief with an example?
How to improve session performance in aggregator transformation?
Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best
What is difference between model & package?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what are the steps to build the data warehouse?
What are the other names given to data warehousing?