Section D: Parameters & Variables
26. What is the primary difference between a parameter and a variable in Informatica?
a) Parameters can change at runtime; variables cannot
b) Parameters are reusable; variables are session-specific
c) Variables retain values across sessions; parameters do not
d) Variables are defined in repository; parameters are not
✅ Answer: c
27. Which type of variable retains its last saved value between workflow runs?
a) Mapping parameter
b) Session variable
c) Persistent variable
d) Workflow variable
✅ Answer: c
28. What is the default behavior of a mapping variable during the first session run?
a) Uses value from the repository
b) Uses start value
c) Uses final value
d) Uses last saved value
✅ Answer: b
29. Which type of parameter allows you to override values at runtime?
a) Workflow parameter
b) Mapping parameter
c) Session parameter
d) All of the above
✅ Answer: d
30. Where are mapping parameters and variables declared?
a) Workflow Manager
b) Repository Manager
c) Mapping Designer
d) Session Properties
✅ Answer: c
Section E: Inbuilt Functions
31. Which function is used to replace null values in a column?
a) ISNULL()
b) DECODE()
c) NVL()
d) IIF()
✅ Answer: c
32. Which function is used to implement conditional logic?
a) DECODE()
b) IIF()
c) CHOOSE()
d) IF()
✅ Answer: b
33. Which function returns the numeric ASCII value of a character?
a) CHAR()
b) CODE()
c) ASCII()
d) ORD()
✅ Answer: c
34. Which Informatica function returns the current system date?
a) TODAY()
b) SYSDATE
c) CURRENT_DATE
d) SYSTIMESTAMP
✅ Answer: b
35. What function would you use to trim both leading and trailing spaces from a string?
a) LTRIM()
b) RTRIM()
c) TRIM()
d) CLEAN()
✅ Answer: c
Section F: Advanced Transformations & Optimization
36. Which transformation is used to insert, update, and delete records in target dynamically?
a) Update Strategy
b) Router
c) Dynamic Lookup
d) Target Definition
✅ Answer: a
37. A dynamic cache in Lookup will:
a) Not change after session start
b) Update only if DD_INSERT is flagged
c) Sync with target table continuously
d) Update based on matching output ports
✅ Answer: d
38. Which performance technique reduces memory usage in Aggregator transformation?
a) Sorted Input
b) Cached Input
c) Reusable Aggregator
d) Data Partitions
✅ Answer: a
39. Why use partitioning in Informatica?
a) Reduce data size
b) Reduce transformation complexity
c) Improve performance
d) Avoid lookup caching
✅ Answer: c
40. Which type of cache persists across session runs?
a) Dynamic cache
b) Persistent cache
c) Shared cache
d) Lookup cache
✅ Answer: b
41. When is a joiner transformation more efficient than a source qualifier join?
a) When sources are from same database
b) When data is already joined at source
c) When sources are from different databases
d) Always
✅ Answer: c
42. Which setting in session properties can improve large data load performance?
a) Enable high precision
b) Enable tracing
c) Enable bulk loading
d) Enable verbose data
✅ Answer: c
43. How can pushdown optimization improve performance?
a) Offloads transformation logic to source/target DB
b) Moves cache to SSD
c) Uses more CPU threads
d) Decreases data types
✅ Answer: a
44. What happens when you enable partitioning on a target?
a) One load path is used
b) Multiple sessions are created
c) Parallel target loading
d) Lookup cache is cleared
✅ Answer: c
45. How can one reduce the number of rows being cached in Lookup transformation?
a) Use SQL override
b) Disable cache
c) Limit session logging
d) Enable dynamic cache
✅ Answer: a
Section G: Scenario-Based
46. A mapping processes daily orders and only new records should be inserted. Which
strategy fits best?
a) Filter with timestamp
b) Lookup + Router + Update Strategy
c) Normalizer
d) Aggregator
✅ Answer: b
47. A flat file with inconsistent delimiters is to be parsed. Which source option helps best?
a) External loader
b) Normalizer
c) Indirect file
d) Flat File Wizard
✅ Answer: d
48. If a target table receives duplicate rows, which is most likely the cause?
a) Router logic
b) Aggregator grouping
c) Improper Joiner condition
d) Persistent cache
✅ Answer: c
49. Which transformation is critical to track changes over time?
a) Expression
b) Update Strategy
c) Lookup with dynamic cache
d) All of the above
✅ Answer: d
50. You want to apply different transformations for high-value and low-value transactions.
What would you use?
a) Filter
b) Expression
c) Router
d) Aggregator
✅ Answer: c
