Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: RubiconCSL
- Order by date
-
optional relationships
What I like to do with all my dimension tables (i.e. lookup tables or your "child" tables) is to create a dummy row, which I always populate when the table is created with a value of -1. Then, whenever you have no real value to enter, put -1 instead of NULL. It is also very helpful...- RubiconCSL
- Post #4
- Forum: MySQL
-
Normalizer Dynamic Occurs
Hi VJ, That is exactly what I have to do, but it isn't a dynamic occurs, in that you have to allow for upto x phone numbers. It would be far more efficient if one could loop until you reach the end of the relevent data i.e. start at the beginning of the string and loop until you know there is...- RubiconCSL
- Post #4
- Forum: Data Management Tools general discussion
-
Normalizer Dynamic Occurs
Lets say you have an input file with a field of comma delimited phone numbers - you don't know how many there will be per record. In the target database, you want one record per phone number. In 'C' for example, you could do a while loop and insert one record per phone number as you traverse...- RubiconCSL
- Thread
- Replies: 3
- Forum: Data Management Tools general discussion
