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 |
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Explain about Informatica server process that how it works relates to mapping variables?
what is difference between dimention table and fact table?
How do we call shell scripts from informatica?
Do you have knowledge in ralph kimball methodology
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 ?
How to create the source and target database connections in server manager?
what are the different types of transformation available in informatica and what are the mostly used ?
How to merge First Name & Last Name?
how to sort date field in infomatica?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
Can we override a native sql query within informatica?