Stack Overflow
Stack Overflow

Questions tagged [flat-file]

A flat-file database model is any system using a single file for storage with one record per line, usually plain-text or text mixed with binary data.

A "flat file" is a plain text or mixed text and binary file which usually contains one record per line or 'physical' record (example on disc or tape). Within such a record, the single fields can be separated by delimiters, e.g. commas, or have a fixed length. In the latter case, padding may be needed to achieve this length. Extra formatting may be needed to avoid delimiter collision. There are no structural relationships between the records.

Typical examples of flat files are /etc/passwd and /etc/group on Unix-like operating systems. Another example of a flat file is a name-and-address list with the fields Name, Address, and Phone Number.

Source: Wikipedia (Flat file database)

830 questions
3
votes
2 answers

How to return multiple values from unconnected lookup?

In my mapping, I am using flat files as source and target. I have to use unconnected lookup. Can somebody tell me how to return multiple values from unconnected lookup specially when we are using flat files as source and target. I know how to return…
Vicky
  • 1,215
  • 6
  • 22
  • 45
3
votes
2 answers

BizTalk flat file schema - produce XML file even if blank flat file received

I am using the BizTalk flat file schema to process CSV files. My schema essentially looks like this:
RationalGeek
  • 9,425
  • 11
  • 62
  • 90
3
votes
1 answer

SSIS Flat File - How to handle file versions / generations

I am working in a data warehouse project with a lot of sources creating flat files as sources and we are using SSIS to load these into our staging tables, we are currently using the Flat File Source component. However, after a while, we need an…
MrSallad
  • 31
  • 2
3
votes
1 answer

Are there any good flat file to object mapping library for C# / .Net?

i've been searching around and was wondering are there any good libraries especially in c# or .net which are made specifically for mapping flat file? so far the only one i found is canyon. thanks
melaos
  • 8,386
  • 4
  • 56
  • 93
3
votes
1 answer

PHP way to get count of lines in file and to move file pointer to specified line?

Is there a way to: count number of lines (1 line = data row) in my small_db.php tell PHP to move file pointer exactly to start of line 322. (so I could fgets() data from this line) tell PHP to return line number or entire content of line in which…
Miloš Đakonović
  • 3,751
  • 5
  • 35
  • 55
3
votes
1 answer

How to create a Biztalk Map that transforms hierarchical XML to flat file

I try to transform a hierarchical XML file to a flat file schema using Biztalk 2010. It works fine. Every file is mapped. But the hierarchy is destroyed. My input xml structure looks like this: …
Tonn Ski
  • 47
  • 1
  • 7
2
votes
1 answer

MATLAB: Transform a flat file list into a multi-dimensional array

I am completely stuck with this: I start out with a flat file type of list I get from an SQL statement like this and want to transform it into a 4D array. SELECT a1, a2, a3, a4, v FROM table A; a1 a2 a3 a4 v -------------- 2 2 3 3 100 2 1 2 2…
Janosch
  • 37
  • 4
2
votes
4 answers

DB2 external tables?

I just heard that Oracle has a feature called External Table that allows to access a flat file (for example a CSV file in the file system) from the database. I just want to know if there is something similar in DB2 for LUW. The closest thing I could…
AngocA
  • 7,655
  • 6
  • 39
  • 55
2
votes
0 answers

Read Flat File to H2 Database using SQL

I'll start off by saying i'm sort of new to SQL, so this question may sound stupid. I have a Flat File with a large quantity of names stored one record per line. the Flat File is in the fore of a .txt I was wondering If it was possible to read the…
Sammy Guergachi
  • 1,986
  • 4
  • 26
  • 52
2
votes
3 answers

Read from a flat file database with PHP

I am looking for the most simple way to pull out a line of data from a flat file database with PHP based on a variable ID number. For example, if the page is passed the ID of 10001 it grabs the first name, last name, company, address, and other…
msargenttrue
  • 425
  • 1
  • 5
  • 11
2
votes
1 answer

csharp flat file database for a standalone windows application

A question like this has been asked differently several times. Yet here i am. I am writing a standalone windows program which will get user input like three fields and have to store it in the disk. Also i need to delete them, edit them and so on. It…
Jayapal Chandran
  • 10,600
  • 14
  • 66
  • 91
2
votes
1 answer

Using BizTalk Flat File Disassembler to split incoming file by larger than 1 record?

I have an incoming flat file that I wish to receive and break into discrete chunks for more efficient processing. There is a nice sample post for BT2010 on getting the flat file disassembler to help with this…
kirps
  • 1,345
  • 2
  • 17
  • 28
2
votes
4 answers

Why is SSIS OLE DB Import Not Importing Last Line of a text File?

I have created a basic Data Flow tasks in SSIS 2008 that is reading information from a a basic text file and importing it into a database. The file is Delimited with lines ending with {CR}{LF} and each field separated by a Vertical Bar {|}. I have…
buzzzzjay
  • 1,140
  • 6
  • 27
  • 54
2
votes
1 answer

Flat File or Database to store small amounts of records. Which would be faster for many connections/users

I Have a web application that will support a large number of connections. Each time a session is created, or a refresh is called, I will run a service that will collect data and store it for viewing. Then using php, read this data from somewhere,…
rlemon
  • 17,518
  • 14
  • 92
  • 123
2
votes
4 answers

Most supported way to protect flatfiles (sqlite db) from HTTP access?

I am developing a PHP application that uses SQLite as database management system, MySQL and PostgreSQL etc. is not an alternative (although I would really like to use pgsql), because I want the setup to be very beginner-friendly and zero-headache…
Patrick Glandien
  • 7,791
  • 5
  • 41
  • 47
1 2 3
…
55 56