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
How can we use external procedural logic in informatica?
What is a staging area? What is the purpose of a staging area?
Explain etl?
Explain about round-robi?
if i have a query as flat file how can we load data to target table
how to load the data to fact table?
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
What are various etl tools in the market?
tell me few points when u become TL
Can u access a repository created in previous version of Informatica?
how do u implement configuration management in Informatica?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
how do u extract data from different data sources explain with an example?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
can cubes contain measures ?