volatile table usage in Informatica

Question

In my Informatica mapping, I need to do the following activities:

1.Creating 'A' volatile table

2.Inserting records into 'A' table, from 'B' normal table

3.Again I want to insert records into 'C' normal table using 'A' volatile table.

How can i do that.Any help is appreciated.

Answer 1

Do you have any logic to impliment after creating the volatile table? what kind of logic(Simple/Complex)? Based on my understanding, here is what you can do. Let me know if you are looking for something else.

You can do this in 2 ways.
1.Create a Stored proc which creates volatile table based on other Multiset table, Impliment logic (If any ) then push it over to Other Multiset table (C)

1. Read from B, Use SQL transformation to create Volatile table, and then insert to Volatile table
   •use volatile table as source and use rest of the transformations and then to Table C.