Interested to Buy Any Domain ? << Click Here >> for more details...
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
- 5 Answers
- 12418 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shiva
just truncate table once and run the session again (or)
in session properties just checke the recovery stratagy as
resume from last check point
if i am wrong plese currecct me
| Is This Answer Correct ? | 4 Yes | 1 No |
"Restart the session" . if the integration service has not issued at least one commit.
(or)
perform "Session Recovery" if the integration service has issued atleast one commit.
the I.S reads row id of last row commited from OPB_SRVR from repository table.
the I.S reads all the data from source , start processing from next row id..
we can perform session recovery when only target load type is normal. it can not support in bulk loading..
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / guest
use dynamic lookup cache so that u can load the data after
load 50 records
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sunny
Did you check if there is any filter in between ?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / lakshmi
If no errors, check if you have set "test rows" to 50 in session property.
| Is This Answer Correct ? | 0 Yes | 0 No |
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
How do we call shell scripts from informatica?
Differentiate between reusable transformation and mapplet.
What are the types of lookup transformation?
What is meant by incremental aggregation?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
What is the difference between procedure and stored procedur?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Teradata 
