-
-
-
-
Updating Target Table
How can we update the target table without using update strategy?
-
-
Target Override
What is a target override table ?
-
-
Session Status
How can we know the session status without workflow monitor?
-
-
How do you identify existing rows of data in the target table using lookup transformation
Can identify existing rows of data using unconnected lookup transformation.
-
-
-
-
Unconnected Lookup
In which situation do we use unconnected lookup?
-
-
What are Target Options on the Servers?
Target Options for File Target type are FTP File, Loader and MQ.
There are no target options for ERP target type
Target Options for Relational are Insert, Update (as Update), Update (as Insert), Update (else Insert), Delete, and Truncate Table. -
Normalizer transformation
How do we normalize data which is in .txt comma seperated by using Normalizer transformation and storing the data in a Dimentional table?
-
Session Performance
How would you improve session performance?
-
What is meant by transformation error
I want to fail the session if the SAL=5000. How can we do it?
-
Find Special Character in Flat File
How to find whether special character is present in flat file's data using Informatica as a ETL tool
Informatica Interview Questions
Ans