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

In session log thier should not be a single error how will
u do

Question Posted / sunil.knl

Answers were Sorted based on User's Feedback



In session log thier should not be a single error how will u do..

Answer / guest

I think the session should run successfully.

regards
Sukanta

Is This Answer Correct ?    1 Yes 0 No

In session log thier should not be a single error how will u do..

Answer / mohith.dmdw

SOME TIMES WE CANNOT GIVE THE DATABASE CONNECTIONS PROPERLY IT DOESNT SHOWS ERRORS IN SESSION PLS CHECK THE DATABASE CONNECTIONS....

Is This Answer Correct ?    1 Yes 0 No

In session log thier should not be a single error how will u do..

Answer / rajeshkumar

If "Stop on Error" value is zero, session will complete successfully. All erroneous data will go into bad file as rejected data. If "Stop on Error" value is 1, session will fail as soon as first error occur.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to load time dimension?

1 Answers   Ford,

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  

what is constraint based load order

2 Answers   Cap Gemini,

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,




When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

scenario

1 Answers  

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

For more Informatica Interview Questions Click Here
Categories