-
Update Strategy
In which situation do we use update strategy?
-
Unconnected Lookup
In which situation do we use unconnected lookup?
-
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?
-
Sequence Generator
Why sequence generator is not directly connected to joiner transformation?
-
Joiner Transformation Cache
What are the caches available in Joiner transformation?What is stored in Joiner cache(data cache) and Index cache?
-
$ & $$ in Mapping or Parameter File
What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?
-
Mapplet Transformations
What are the transformations not used in mapplet and why?
-
Dimension Table Vs Fact Table
What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica.
-
Convert Source Column into Target Rows
What transformation do you use to convert source column into target rows? Explain
-
Load the remaining rows
Suppose there are 100,000 rows in the source and 20,000 rows are loaded to target. Now in between if the session stops after loading 20,000 rows how will you load the remaining rows?