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

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

Explain how many types of dimensions are available in informatica?

0 Answers  

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

What is difference between a connected look up and unconnected look up?

6 Answers  




Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

What are the active and passive transforamtions?

2 Answers  

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  

For more Informatica Interview Questions Click Here
Categories