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?
Answer Posted / rakhee
Try using mapplet variable
It helps to load data in the part.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is workflow? What are the components of the workflow manager?
What is event and what are the tasks related to it?
If informatica has its scheduler why using third party scheduler?
how to load rows into fact table in data warehouse
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the different versions of informatica?
What is informatica powercenter repository?
What is an active transformation?
How to extract the informatica rejected data?
How can repository reports be accessed without sql or other transformations?
Explain sessions and how many types of sessions are there?
Mention some types of transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?