Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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?

Answers were Sorted based on User's Feedback



when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want ..

Answer / bsgsr

hi, suresh,
go for session recovery if you run in normal mode.
if it is a bulk mode session only option is to truncate the
table and run the session again.

Is This Answer Correct ?    22 Yes 1 No

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want ..

Answer / raveendra g

By using Performance recovery option we can close this
issue.

Is This Answer Correct ?    3 Yes 0 No

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want ..

Answer / dhananjaya

use transaction control transformation

Is This Answer Correct ?    1 Yes 0 No

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want ..

Answer / rakhee

Try using mapplet variable
It helps to load data in the part.

Is This Answer Correct ?    0 Yes 0 No

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want ..

Answer / powerstar

session recovery works much better if it is run in normal mode.
If the load type is bulk mode, then session recovery is compromised.

Is This Answer Correct ?    0 Yes 0 No

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want ..

Answer / 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

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want ..

Answer / gayathri

Go to workflow manager. choose mapping. There u uncheck the
box truncate table. This shd. load ur remaining rows
without truncating the previously loaded records.

Is This Answer Correct ?    1 Yes 11 No

Post New Answer



More Informatica Interview Questions

What are the basic needs to join two sources in a source qualifier?

4 Answers  


How informatica process data means how informatica works?

2 Answers   TCS,


How to delete the data in the target table after loaded.

3 Answers   TCS,


1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,


In which scenario did you used pushdown optimization?

1 Answers  






What is event and what are the tasks related to it?

0 Answers  


how to obtain performance data for individual transformations.

2 Answers  


how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


When will you use SQL override in a lookup transformation?

1 Answers  


what is bridge tables in informatica

1 Answers   CTS,


how you will maintain version?

3 Answers   CTS, TCS,






Categories