Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between flat files and relational sources?
- 2 Answers
- 6204 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 |
Explain the use lookup tables and Aggregate tables?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
When do we go for the tools in the market?
what is session partitioning?
Explain and compare etl & manual development?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
how do u handle performance issues in Informatica . where can u monitor the performance ?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
can cubes contain measures ?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
what is meant by drill through?(Mascot)
what are Lookup caches options? Including persistent caches.
Teradata 
