Can any one describe what is audit table briefly?how does it
look like
and what are the columns in it?

Answer Posted / rayudu

WKFL_RUN_ID
WKFL_NME
START_TMST
END_TMST
ROW_INSERT_CNT
ROW_UPDATE_CNT
ROW_DELETE_CNT
ROW_REJECT_CNT


Above are the some of the sample columns


regards,
rayudu

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a filter transformation and why it is an active one?

560


what is the complex transformation you used in informatica

2186


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

546


How can you increase the performance in joiner transformation?

704


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3444






If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8534


What are mapplets?

814


How to update or delete the rows in a target, which do not have key fields?

651


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1204


What can we do to improve the performance of informatica aggregator transformation?

616


What is the difference between stop and abort in informatica

658


Define joiner transformation?

590


Explain how to import oracle sequence into informatica?

590


How can one identify whether mapping is correct or not without connecting session?

875


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1733