Difference between flat files and relational sources?
- 2 Answers
- 5582 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasanna
if ur sources are flat files then you cannot give any SQ
override queries.
to join 2 flatfile sources you need to have a joiner
transformation.
If ur target is a flat file, the loading process is very
fast as its a bulk load where there will be no constraints
( no checks)
You can have number and char data types... but for dates,
you need to convert explicitly
many more diff are there...
You can use indirect method and use many flatfiles of same
structure and load to a target using one session and
workflow tasks.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
can be used COM component in Informatica ?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
What is data modeling and data mining?
How many types of transformations supported by sorted input?
Do we need an ETL tool? When do we go for the tools in the market?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What are the steps involved in etl process?
when should one create lookup transformation ?
Hi, Lookup() is what kind of join ?
Teradata 
