What are the circumstances that infromatica server results
an unreciverable session?
Answer / swetha
The source qualifier transformation does not use sorted ports.
If you change the partition information after the initial
session fails.
Perform recovery is disabled in the informatica server
configuration.
If the sources or targets changes after initial session fails.
If the maping consists of sequence generator or normalizer
transformation.
If a concuurent batche contains multiple failed sessions.
| Is This Answer Correct ? | 2 Yes | 0 No |
HOW DO YOU CONNECT TO REMOTE SERVER ?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
Can we combine a flatfile and a database table using an UNION transformation?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
what is Partitioning ? where we can use Partition?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
in performance wise union is past,union all is past
How to handle changing source file counts in a mapping?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
what happens when a batch fails?