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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with a Hash-file
Thanks JGirl & vmcburney for the suggestions. I decided to do some more tinkering and found another way to do it! I still used the same transform with the flat-file input and hash-file reference -> but, I "cheated". Since vmcburney says that I'm limited to an equijoin, then I thought: "if you...- dutchred
- Post #4
- Forum: Data Management Tools general discussion
-
Help with a Hash-file
Problem: I have a flat file with 10 columns, one column is a date-field. This is input to a transform-stage. Then, I have a hash-file with a single record, containing a date-field. This is input to the same transform as a 'reference'. I want to get all the records from the flat-file where it's...- dutchred
- Thread
- Replies: 3
- Forum: Data Management Tools general discussion
-
Question Re: Using an Excel file as Input to DataStage
How do you setup an Excel file as input to DataStage. I've tried using the "sequential file" stage, and that doesn't work. Then I thought of using "OLE/DB" stage, and tried a number of drivers for Excel, and still couldn't get it to work. Anyone here ever done this successfully ? Thanks in...- dutchred
- Thread
- Replies: 1
- Forum: Data Management Tools general discussion
