Difference between flat files and relational sources?
Answer Posted / maruthi
FLAT FILES SOURCES WILL WITHOUT PRIMARY KEY AND ALL THE
COLUMN DATATYPES WILL BE SIMILER. I.E--CHAR.
RELATIONAL SOURCES WILL BE WITH PRIMARY KEY AND FOREIGN KAY
REALTION SHIP
THIA IS THE MAIN DIFFERENCE,A LOT OF SMALL DIFFERENCES ARE
THEIR.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Is hadoop a etl tool?
what are the types in error loging?
explain the methodology of Data Warehousing?(Polaries)
what is pmrep command?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Which transformation we use to convert 'NA' to 'Not Available'
Explain about power designer data modeling software?
What is lookup table in etl testing?
what is session partitioning?
what is an ETL or ETT? And what are the different types?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What are the etl testing operations includes?
What are the different etl testing categories as per their function?
Can we create Hierarchies in generic datasources?
Explain the use lookup tables and Aggregate tables?