when i was running the seesion, after loading 100 records,
session suddenly fails.Next time i want to load the remaing
rows in target with out truncate target table.What should i
use?
- 7 Answers
- 14984 Views
- Cegedim, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
gayathri,
if you work in the same manner probably there is a chance
of record duplicates to be loaded if you restart the session
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is a stored procedure transformation?
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
Write the program through which the records can be updated?
Mention few power centre client applications with their basic purpose?
Explain pushdown optimization and types in informatica
Explain sql transformation in script mode examples in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is a filter transformation and why it is an active one?
Explain load alternative records / rows into multiple targets - informatica
How to create a non-reusable instance of reusable transformations?
What is workflow manager?
Explain the different lookup methods used in informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the issues you have faced in your project? How did you overcome those issues?
What is source qualifier transformation in informatica?
