1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / maheedhar

Answers were Sorted based on User's Feedback



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

Answer / rayudu

Audit Table is nothing but the table which contains abouut
your workflow names and session names .It contains
information abt workflow and session status and their details.

Regards,
rayudu

Is This Answer Correct ?    4 Yes 0 No

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

Answer / maheedhar

Rayudu can u please tell me what are the columns in it

Is This Answer Correct ?    0 Yes 0 No

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

Answer / 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

More Informatica Interview Questions

explain about session partitions ?

1 Answers  

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

what is the flow?

1 Answers  

permutations of mapplet

0 Answers   TCS,

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  




Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

Briefly describe lookup transformation?

0 Answers  

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

What are the different threads in DTM process?

2 Answers  

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

For more Informatica Interview Questions Click Here
Categories