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
Answer Posted / 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 |
Post New Answer View All Answers
Explain transaction control transformation in informatica
How to call shell scripts from informatica?
What is a dimensional model?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What does reusable transformation mean?
What are the differences between joiner transformation and source qualifier transformation?
What all are steps in up gradation of Informatica server?
What is a joiner transformation and why it is an active one?
Explain the etl program with few examples.
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain direct and indirect flat file loading (source file type) - informatica
How do you handle two sessions in Informatica
What is dynamic cache?
What is joiner transformation in informatica?