-
Create Index
How Create Index in Oracle? explain with example
-
Star Schema
One fact table is surrounded by only one dimension table. Is it star schema or not? Give any real time example?
-
$ symbol
$, $$, $$$ what these symbols represents in Informatica?
-
Pipeline Partitioning
Explain the pipeline partitioning with real time example.
-
Lookup Query
What kind of join (Inner,Outer,FULL) does a lookup generate while being used in a mapping in order to search for a particular field value?
-
Aggregate Value
Explain a mapping design to start aggregating the values before getting all the rows from the source.
-
Passive Router Transformation
Router is passive transformation, but one may argue that it is passive because in case if we use default group (only) then there is no change in number of rows. What explanation will you give?
-
Error handling Logic
How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target?
-
Union Transformation
Why Union transformation is active while it returns same number of rows as in the sources?
-
-