Infosys Certified Informatica PowerCenter Developer
Practice with real exam-pattern questions for Infosys Certified Informatica PowerCenter Developer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Informatica PowerCenter Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Informatica PowerCenter Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
What type of a transformation is the Rank Transformation?
- ✓ Active, Connected Correct
- B Passive, Connected
- C Active, Unconnected
- D Passive, Unconnected
- Question 2
Rebuilding the indexes of a table after loading a table can be done as
- ✓ Pre-session SQL command Correct
- B Post-session SQL command
- C Either Pre or Post-session SQL command
- D None of the choices
- Question 3
Joining two tables in a source qualifier generates the default join as
- ✓ inner equi join Correct
- B outer join
- C full outer join
- D no default join
- Question 4
Which object can not be used in mapplet?
- ✓ Target definition Correct
- B Sequence Generator
- C Stored Procedure transformation
- D Source definition
- Question 5
When user change a column name in existing Source definition:
- ✓ If you change the column name for an existing column, the mapping is invalidated. Correct
- B Mappings are not invalidated.
- C User cannot change existing column name
- D Column name can be changed only if it is not linked to any input port.
- Question 6
In a Router transformation, rows which do not meet any test condition are routed to
- ✓ Session logs Correct
- B Reject files
- C Default Output Group
- D Both Session logs & Rejected files
- Question 7
What will be the result of IIF( SALARY < 0, ERROR ('Error. Negative salary found.', EMP_SALARY) when SALARY is less than 0.
- ✓ The session will failed with error message "'Error. Negative salary found." Correct
- B The notification email will be sent with error message "'Error. Negative salary found."
- C The row will be skipped and with error message "'Error. Negative salary found." in the session log.
- D The row will be skipped and session will be failed with error message "'Error. Negative salary found." in the session log.
- Question 8
The transformation which can be used as both connected and unconnected
- ✓ Filter transformation Correct
- B Rank transformation
- C Lookup transformation
- D Normalizer transformation
- Question 9
Specifying the "Number of Sorted ports" property in a source qualifier performs the sort in
- ✓ the database Correct
- B the informatica memory
- C both the database and informatica memory
- D None of the choices
- Question 10
The Integration Service initializes the variables ports according to the
- ✓ Default value specified Correct
- B Datatype of the variable
- C Either Default value or by datatype
- D If default value is not specified, then variable is initialized according to the datatype.
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.