generate a unique number and insert i...

generate a unique number and insert into a table

Posted in the Informatica Forum

Arvind

Chennai, India

#1 Jul 6, 2011
Hello All,

I have requirement and need a logic to implement the same.

My source system is Siebel.
Target system is Oracle.

Step 1:

Whenever we transfer records from Table A in Siebel to Table B in Oracle we have to make an entry to a table C present in Oracle.This table C has following fields Batch_id,batch_start_time,stat us and batch end_time.

Before actual load begins from Table A to Table B we have to insert single row in table C with following values

Batch _id : Unique number to identify each load.
start_time: Sysdate

This entries has to be made before actual data load from Table A to table B.After all the records has been transferred successfully from Table A to Table B we have to update status and batch_end_time in Table C.

Step 2:

Also there is a column in actual Target table B called Batch_id.For every record inserted in Table B it should have the Batch_id (which was generated in step-1 )

Example:

Consider Iam planning to load 50 records from table A into Table B.

1.At first we have to generate a unique number say 1234 as batch_id and insert this number in table C along with sysdate
2.Now for every records(all 50 records) loaded in Table B should have this value 1234.

Could you please help me to implement this logic?

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Informatica Admin & Cloud Deployment (May '17) May '17 avi_infa 1
Converting row data to column data (Sep '16) Sep '16 Roopa 1
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul '16 ann_p 2
active and passive t/f (Feb '16) Jul '16 ann_p 2
Loading a specific Erwin model version into Met... (Apr '16) Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... (Mar '16) Mar '16 anil 1