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 Distinct and Duplicate values to different targets
This is a discussion on Load Distinct and Duplicate values to different targets within the Data Warehousing forums, part of the Databases category; I have a scenario in which the source consists of 2 cols 10 A 10 A 20 C 30 D 40 E 20 C and there are 2 targets one ...
|
|||||||
02-24-2008
|
|||
|
|||
|
Load Distinct and Duplicate values to different targets
I have a scenario in which the source consists of 2 cols
10 A 10 A 20 C 30 D 40 E 20 C and there are 2 targets one to load distinct values and another one to load duplicate values. T1 T2 10 A 10 A 20 C 20 C 30 D 40 E How to load 
|
| Sponsored Links |
|
02-25-2008
|
|||
|
|||
|
Re: Load Distinct and Duplicate values to different targets
Use an Aggregator Transformation and in the transformation, using count function, try to find out if there are duplicates or not. After aggregator, use a router and route the values based on the count. Hope this helps
|
| The Following User Says Thank You to ramud2 For This Useful Post: | ||
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| remove duplicate values in a source using Informatica | JobHelper | Data Warehousing | 5 | 8 Hours Ago 04:48 PM |
| difference bet unique and distinct | smitai | Oracle Certification | 4 | 3 Weeks Ago 08:35 AM |
| Load Relatonal Targets | suneetharoy | Data Warehousing | 1 | 09-03-2007 06:45 AM |
| How to load variables and values from external file | prasad79 | QTP | 1 | 05-02-2007 03:00 PM |
| I want load the duplicate records to seperate table | Geek_Guest | Data Warehousing | 4 | 04-06-2007 03:10 AM |
All times are GMT -4. The time now is 01:13 AM.
