Explain how to get the first 100 rows from the flat file into the target?
Answer / Arun Kumar Rao
"To get the first 100 rows from a flat file into the target, you can use a SQL statement with the LIMIT clause. For example, in SQL Server: SELECT TOP 100 * FROM file_name; In MySQL: SELECT * FROM file_name LIMIT 100;"
| Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by metadata in context of a data warehouse and how it is important?
Explain what are data marts?
What are data modeling and data mining?
Explain what is real time data-warehousing?
Difference between e-r modeling and dimentional modeling?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
What is a look up function? What is default transformation for the look up function?
What is cfapplication tag?
What are the stages that are required in data warehousing?
What are the different types of segments?
What is the difference between Oracle Express and Oracle Discoverer?
What we will do with the universe for faster process?