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. |
Problem in loading to target
This is a discussion on Problem in loading to target within the Data Warehousing forums, part of the Databases category; Hi, I have 3 files suppose A,B and C. These are flat files. I want to load them into two target tables . they are data base tables. In first ...
|
|||||||
06-12-2009
|
|||
|
|||
|
Problem in loading to target
Hi,
I have 3 files suppose A,B and C. These are flat files. I want to load them into two target tables . they are data base tables. In first target I would like to load all the data. In second target I wan the file names i.e. A, B and C Please help me in this. Thanks in advance Regards Puspa 
|
| Sponsored Links |
|
06-12-2009
|
|||
|
|||
|
Re: Problem in loading to target
I don't know what tool you are using but, to load all three flat files into a single table, they must have the same exact columns. 1) Create three separate actions and insert the files sequentially into the target table. 2) For the second load do the same thing as the first transformation and add the step of creating a derived column and inserting the value of A,B,C according to the file name.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Loading JRE | rijus | Java | 0 | 05-17-2009 04:44 AM |
| Diff b/w Eager loading and Lazy Loading | dshaktikumar | Java | 3 | 12-04-2008 05:45 PM |
| i want loading data into target remove source | b sivareddy | Quality Center | 0 | 09-28-2008 03:17 AM |
| Loading for 6th Record | JobHelper | Data Warehousing | 5 | 07-08-2008 10:01 AM |
| I want to load 1,3,5 in one target and 2,4,6 in 2nd target | Geek_Guest | Data Warehousing | 1 | 01-18-2008 08:51 AM |
All times are GMT -4. The time now is 06:46 PM.
