Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Load 3 flat file in single shot
This is a discussion on Load 3 flat file in single shot within the Data Warehousing forums, part of the Databases category; I have three flat file source and i want to process (ie load them) in single shot i.e., not one by one. How I can achieve this?...
|
|||||||
09-24-2007
|
|||
|
|||
|
Load 3 flat file in single shot
I have three flat file source and i want to process (ie load them) in single shot i.e., not one by one. How I can achieve this?
|
| Sponsored Links |
|
09-25-2007
|
|||
|
|||
Re: Load 3 flat file in single shot
Quote:
This is very simple when your three Source flat files are under same location. Keep all the three files in a directory first. then Goto -> session properties -> Mappings tab ---> select Sources In Source properties, under File Reader tab -> Provide the path of the file containing the path of 3 files. Your loading completes. If these three files are located at different places (Directories) - This will not solve. www.sanghala.com
__________________
Sanghala www.dwforum.net - A Great resource for Data Warehousing Professionals If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
|
| The Following User Says Thank You to sanghala For This Useful Post: | ||
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Split a single large XML file in Gigabytes into 200MB chunks | Geek_Guest | Data Warehousing | 1 | 3 Days Ago 08:01 PM |
| Selected row from mid of flat file | mathavadoss | Data Warehousing | 1 | 09-20-2007 01:33 AM |
| Load data from a flat file to two different relational tables | madarapu | Data Warehousing | 1 | 07-10-2007 07:13 AM |
| Can Informatica V7 support flat file with multiple record type | Geek_Guest | Data Warehousing | 0 | 07-06-2007 09:56 AM |
| Transfer data from flat file to staging tables | Geek_Guest | Oracle Apps | 0 | 02-24-2007 05:56 AM |
All times are GMT -4. The time now is 08:26 AM.
