Can any one describe what is audit table briefly?how does it look like and wh

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

Question Posted / maheedhar

3 Answers
8903 Views
Syntel, I also Faced
E-Mail Answers

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..

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

Which transformation should u need while using the cobol sources as source defintions?

2 Answers

What is power center repository?

1 Answers

what is system requirement(SR) & business requirement(BR)?

2 Answers Ness Technologies,

How many dimensions are there in informatica?

0 Answers

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers IBM, TCS,

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers Mind Tree, Polaris,

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers Cap Gemini, IBM,

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers HCL,

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers

How do you join more than 3 flat files in informatica?

1 Answers ITC Infotech,

Without using any transformations how u can load the data into target?

15 Answers IBM,

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers

For more Informatica Interview Questions Click Here