Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17129 Views
- Cegedim, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / dhananjaya
use transaction control transformation
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the types of caches in lookup?
What is repository manager?
What does “tail –f” command do and what is its use as an Informatica admin.
can u give example for factless fact table
wf dont have integration severances how you can run?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to create the source and target database connections in server manager?
Explain about cumulative Sum or moving sum?
Explain the shared cache and re-cache?
How might you approve all mappings in the archive all the while?
Define mapplet?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to do the error handling of if ur source is flatfiles?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
