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
What is a filter transformation and why it is an active one?
what is the complex transformation you used in informatica
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?
How can you increase the performance in joiner transformation?
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
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?
What are mapplets?
How to update or delete the rows in a target, which do not have key fields?
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.
What can we do to improve the performance of informatica aggregator transformation?
What is the difference between stop and abort in informatica
Define joiner transformation?
Explain how to import oracle sequence into informatica?
How can one identify whether mapping is correct or not without connecting session?
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