How can you complete unrcoverable sessions?

Answer Posted / swetha

Under certain circumstances, when a session does not
complete, you need to truncate the target tables and run the
session from the beginning. Run the session from the
beginning when the Informatica Server cannot run recovery or
when running recovery might result in inconsistent data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

797


Explain direct and indirect flat file loading (source file type) - informatica

815


How can we delete duplicate rows from flat files?

733


How might one distinguish in the case of mapping is right or not without associating session?

636


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1863






What is the need for an etl tool?

628


Explain scd type 3 through mapping.

576


how tokens will generate?

1723


Informatica settings are available in which file?

581


Explain lookup transformation is active in informatica

652


scenario where i can use only concurrent execution of workflow.

2530


What are the different transaction levels available in transaction control transformation?

671


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

669


What is intricate mapping?

583


What is dimensional table? Explain the different dimensions.

645