There will be 6 questions from this topic. There is one entire pdf document is talking about this topic. You can download the document from the below url. This describes how you can use constants, operators, variables, dates, and functions to transform source data.

Transformation Language

What to study & Where to focus

Even-though its a vast topic which cover all the SQL-like functions to transform source data, you can focus on the below listed topics for your certification exam. 

• Constants used in update strategy dd_insert, dd_reject, dd_update, dd_delete - (Page 17-19)
• String functions - INSTR, CHOOSE, REG_MATCH, REPLACECHR, DECODE, SUBSTR
• Special functions like - ABORT, ERROR (Page 52,90)
• Date functions - TO_DATE, IS_DATE, TO_CHAR(Date) (Page 32)
• Understand the Date format strings, Difference between YY & RR (Page 40)
• Constants TRUE, FALSE, NULL (Page 19-21)
• How NULL values behaves in Aggregate, filter conditions and in expressions (Page 19-21)

Need Help? email me! 

Liked the content??
Please Like FB page & subscribe the channel!
Let's learn together!

Informatica Certification test topics.
Informatica Certification questions.
Informatica Certification sample questions.
Informatica Certification syllabus.
Informatica skill set Inventory.
Informatica PowerCenter Specialist Certification.
Informatica PowerCenter Data Integration 10 Developer Specialist Certification.
Informatica Developer Specialist Certification.
Informatica Certification preparation.
Informatica certification sample questions.
Informatica certification dumps.

#informatica #PowerCenter #DataIntegration #Developer #Specialist #Certification