top button
Flag Notify
Site Registration

volatile table usage in Informatica

+1 vote
633 views

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.

posted May 2, 2014 by Rohini Agarwal

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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.
answer May 6, 2014 by Shweta Singh
Similar Questions
0 votes

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 to do that?

0 votes

Suppose if we have duplicate records in a table temp_n. Now I want to pass unique values to t1 and duplicate values to t2 in single mapping? How can we achieve?

0 votes

Can anyone tell me how to find the list of mapping and the workflow that are using a particular table say X either as a source or target table?

...