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


Please Help Members By Posting Answers For Below Questions

What are the differences between oltp and olap?

527


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4926


What is primary and backup node?

666


How to update or delete the rows in a target, which do not have key fields?

629


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1557






Explain about Informatica server process that how it works relates to mapping variables?

600


Explain the use of aggregator cache file?

646


Define joiner transformation?

569


Different qualification between a related rotate toward the sky and isolates look upward?

531


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1871


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1706


Explain constraint based loading in informatica

635


what is the -ve test case in your project.

1825


How to generate or load values in to the target table based on a column value using informatica etl tool.

590


Please let me know how to make Data masking in informatica..

1240