Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between flat files and relational sources?
- 2 Answers
- 6090 Views
- I also Faced
- E-Mail Answers
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
what is the use of structures?how many nodes can u create in a structure?
what are the session parameters? How do u set them?
What is virtual Data Warehousing?
Which transformation we use to convert 'NA' to 'Not Available'
What is lookup table in etl testing?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Do we need an ETL tool? When do we go for the tools in the market?
Explain about round-robi?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Explain do we need an etl tool?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is a staging area? What is the purpose of a staging area?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain and compare etl & manual development?
what happens if the info.server doesn't find the session parameter in the parameter file?
