Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

Difference between flat files and relational sources?

Question Posted / jakki

Answers were Sorted based on User's Feedback



Difference between flat files and relational sources?..

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

Difference between flat files and relational sources?..

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

Post New Answer

More ETL Interview Questions

what is different between sequential batch and concurrent batch and which is recommended and why?

0 Answers  

what is a worklet?

0 Answers  

how does the server recongnise the source and target databases.Elaborate on this

0 Answers   Accenture,

what is pmrep command?

1 Answers  

what are variable ports and list two situations when they can be used?

4 Answers   Satyam,

How to increase performance without changing anything in mapping.( In prod)

0 Answers   IBM, Saama Tech, Wipro,

How etl testing is different from database testing?

0 Answers  

Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

320 Answers   Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 Answers  

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

What is partitioning? Explain different types of partitioning?

0 Answers  

what is session partitioning?

0 Answers  

For more ETL Interview Questions Click Here
Categories