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
- 12030 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 |
Is there any model difference between ODS and DWH
What are mapplets? How is it different from a Reusable Transformation?
What is the different lookup cache(s)?
What happens if we dont select data driven option?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
Can you start a session inside a batch individually?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Teradata 
