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. |
I want to load odd number records into one target table
This is a discussion on I want to load odd number records into one target table within the Data Warehousing forums, part of the Databases category; Hi friends, my question is I have 100 records in a source flat file. I want to load odd number records into one target table & even number records into ...
|
|||||||
04-03-2007
|
|||
|
|||
|
I want to load odd number records into one target table
Hi friends, my question is
I have 100 records in a source flat file. I want to load odd number records into one target table & even number records into another target table. Using Informatica how can we do this ? Thanks inadvance. 
|
| The Following User Says Thank You to ggk.krishna For This Useful Post: | ||
| Sponsored Links |
|
04-17-2007
|
|||
|
|||
|
Re: I want to load odd number records into one target table
use a router transformation and groups with even and odd
for even records give a condition id%2=0 odd records id%2>0 this my idea if id is number.Try it if it not works try anther expression on which column based u want to split that records ok
|
|
04-17-2007
|
|||
|
|||
|
Re: I want to load odd number records into one target table
Hi Jagadishwar,
Thanks for your reply. I used some other condition i.e mod(num,2)=0 for even number in router transformation. Its working. num is the column created to hold the serial number, and are generated using sequence generator transformation. According to your answer, can we use rowid in any expressions for flat files?  Thanks & Regards, G Gopi Krishna. Quote:
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| plz let me know about Load size in load testing | prakashnemesis | Testing Issues | 4 | 08-19-2008 02:26 AM |
| I want load the duplicate records to seperate table | Geek_Guest | Data Warehousing | 4 | 04-06-2007 02:10 AM |
| How can I show my next target page through jsf | abhinav83shukla | Java | 0 | 02-28-2007 05:50 AM |
| Source and Target connection value in the lookup | sat.inn | Data Warehousing | 0 | 02-26-2007 02:34 AM |
| Want to load some 1000 records to target | Geek_Guest | Data Warehousing | 0 | 02-21-2007 03:08 AM |
All times are GMT -4. The time now is 11:02 PM.
