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 from source to different targets
This is a discussion on Load from source to different targets within the Data Warehousing forums, part of the Databases category; Scenario I have one table with 100 records. I have 5 diff targets.. From the source the first row should go to 1 target , II row to II target ...
|
|||||||
03-19-2008
|
|||
|
|||
|
Load from source to different targets
Scenario
I have one table with 100 records. I have 5 diff targets.. From the source the first row should go to 1 target , II row to II target etc V th row to 5 th tgt.. Again 6 th row to 1 , 7 row to 2 tgt.. etc.. How to do this? 
|
| The Following User Says Thank You to raju.pk For This Useful Post: | ||
| Sponsored Links |
|
03-31-2008
|
|||
|
|||
Re: Load from source to different targets
Quote:
Can u please explain me how to use Round robin partition. I am novice to DW and never heard of this before. Thanks in advance, Divya
|
|
04-01-2008
|
|||
|
|||
|
Re: Load from source to different targets
I dnt know about Round Robin thing. You can achive this by using sequence generator transformation..
1) Import ur source table. 2) create a sequence generator transformation start by one n increment by one. 3) create expression transformation, get mod(NEXTVAL,5). Next one more field use decode function DECODE(mod_value,1,1,2,2,3,3,4,4,0,5) 4) Then pass them to router to route them to different targets based on decode value.
|
| The Following User Says Thank You to Divya.B.V For This Useful Post: | ||
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Open source Load Testing Tool | bhaskar.srikrishna | Testing Issues | 2 | 12-08-2008 05:06 AM |
| Load Distinct and Duplicate values to different targets | tanya123 | Data Warehousing | 1 | 02-25-2008 09:06 PM |
| Generate targets flat files by transaction | FLIMA | Data Warehousing | 0 | 11-27-2007 05:55 AM |
| Load Relatonal Targets | suneetharoy | Data Warehousing | 1 | 09-03-2007 06:45 AM |
| File having 12 records I have to send data to different targets | rasmi | Data Warehousing | 4 | 06-28-2007 11:15 AM |
All times are GMT -4. The time now is 08:12 PM.
