Difference between flat files and relational sources?
- 2 Answers
- 5189 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
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What are dimensions?
What is etl process?
what is the difference between cubes and package in cognos
what is session partitioning?
Explain about the data integration suite features?
What do you understand by active and passive transformations?
Explain etl mapping sheets?
Difference between flat files and relational sources?
Is apache nifi an etl tool?
what is the meant by Normalization and de-normalization?
what is a worklet?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
How to fine tune mappings?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
