Explain if a flat file cotains 1000 records how can I get first and last records only?
No Answer is Posted For this Question
Be the First to Post Answer
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
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 meetthe condition.
5.Explain ODS ?
What are the different types of fact tables used in data warehousing?
Why should we use data ware housing and how can you extract data for analysis with example?
Why null values are mapped as 0 in fact tables?
Explain what are the mapping paramaters and maping variables?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is Analysis Services?
What is the 4 + 1 view model as it relates to system modeling?
Tell me one example for junk dimension?
What is Snow Flake Schema design in database?