-
-
-
How many ways you can update a relational source definition ?
Two ways 1. Edit the definition 2. Reimport the defintion
-
Mapplet Transformations
What are the transformations not used in mapplet and why?
-
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.
-
-
What are Aggregate transformation?
Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.
-
What are Target Types on the Server?
Target Types are File, Relational and ERP.
-
-
What is Data Transformation Manager?
After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process is to create and manage threads that carry out the session tasks.· The DTM allocates process memory for the session and divide it into buffers. This is also known as buffer memory. It creates the main thread,...
-
What is a Source Qualifier?
It represents all data queried from the source.
-
What are various types of Aggregation?
Various types of aggregation are SUM, AVG, COUNT, MAX, MIN, FIRST, LAST, MEDIAN, PERCENTILE, STDDEV, and VARIANCE.
-
-
-
-
What is Join index
Hi everyone ,Can u explain in detail what is a join index,with example.And what is its importance in teradata.
-
$ & $$ in Mapping or Parameter File
What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?
-
Convert Source Column into Target Rows
What transformation do you use to convert source column into target rows? Explain
-
What is Session and Batches?
Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches...
-
Informatica Interview Questions
Ans