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. |
In my source table I have two columns
This is a discussion on In my source table I have two columns within the Data Warehousing forums, part of the Databases category; In my source table I have two columns, there values like 1 A1 B1 C2 G2 H2 I3 L3 M I want to get in target like this... 1 A*B*C2 ...
|
|||||||
06-15-2007
|
|||
|
|||
|
In my source table I have two columns
In my source table I have two columns, there values like
1 A1 B1 C2 G2 H2 I3 L3 M I want to get in target like this... 1 A*B*C2 G*H*I3 L*M Please anyone can solve this... Thanks in advance... Question asked by visitor Haritha 
|
| Sponsored Links |
|
06-18-2007
|
|||
|
|||
|
Re: In my source table I have two columns
Question wasn't clear
__________________
Thx SRIRAM N Hope Everything Good
|
|
03-18-2008
|
|||
|
|||
|
Re: In my source table I have two columns
Dear Friend,
Could you please more specific with your question? Because the question is not very clear.
|
|
03-26-2008
|
|||
|
|||
|
Re: In my source table I have two columns
Hi,
If im not mistaken ur qn is Src 1 A 1 B 1 C 2 G 2 H 2 I 3 L 3 M I want to get in target like this... 1 A*B*C 2 G*H*I 3 L*M U can designate the column names as ID and NAME. Use an expression transformation.Declare two variables for ID and NAME. ie NAME_V PORT use the expression IIF(ID_V=ID,NAME_V||'*'||NAME,NAME) ID_V PORT IIF(ID_V!=ID,ID,ID_V) Next pass these ports to an aggregator transformation and do GROUP BY ID. Then pass to target.. Try this ..It will work perfect... Regards Tanya
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to add values to other columns | Mohamed_Rafi | Oracle | 10 | 03-27-2008 12:35 AM |
| Joining Tables and mapping columns | JobHelper | SQL | 1 | 08-20-2007 02:30 PM |
| How to know all the mandatory columns that need to be filled | Geek_Guest | Oracle Apps | 0 | 05-13-2007 05:36 AM |
| How a java table be brought to data table? | dhandhan | QTP | 0 | 04-15-2007 06:14 AM |
| Source of Job | christia | Interviews | 2 | 08-09-2006 07:57 AM |
All times are GMT -4. The time now is 07:49 AM.
