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. |
This is a discussion on Can we implement a cursor looping logic within the Data Warehousing forums, part of the Databases category; Can we implement a cursor looping logic (from pl/sql) into Informatica on a set of dates.Ex: if the cursor has 4 inserts and then 2 updates statements, then we have ...
|
|||||||
|
|||
|
Can we implement a cursor looping logic
Can we implement a cursor looping logic (from pl/sql) into Informatica on a set of dates.Ex: if the cursor has 4 inserts and then 2 updates statements, then we have loop the entire cursor for each date (loop the 4 inserts and updates) and then again come to the starting of the cursor and loop the entire cursor with 2nd date.
Can anyone give us any inputs how this logic can be implemented in informatica. (For every date the target shud be loaded and again take the next date insert,update and load into target and so on till some Enddate.) |
| The Following User Says Thank You to JayaSravani For This Useful Post: | ||
| Sponsored Links |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to implement inheritance in HBM mapping? | Geek_Guest | Java | 0 | 07-17-2007 11:29 PM |
| ref cursor giving error | bhaski | SQL | 2 | 07-10-2007 09:19 AM |
| Name for Implicit Cursor | Geek_Guest | Oracle Apps | 0 | 04-08-2007 06:53 AM |
| cursor to array. | Barbie | Oracle | 1 | 02-06-2007 08:57 AM |
| what is the logic behind this ? | psuresh1982 | Brainteasers | 7 | 02-05-2007 03:38 AM |