SIVA.123

SUBMITTED BY: SIVA.123

DATE: June 21, 2024, 10:17 a.m.

FORMAT: Text only

SIZE: 5.1 kB

Raw Download

HITS: 245

Report
  1. What are Transformation Types with examples in Informatica?
  2. Informatica is a powerful data integration tool used to extract, transform, and load (ETL) data across various sources and destinations. Transformations are the core of Informatica’s data processing capabilities, allowing for the manipulation of data as it moves through a workflow. Informatica Online Training
  3. Here are the main types of transformations in Informatica, along with examples:
  4. 1. Source Qualifier Transformation
  5. • Purpose: Converts source data into a format that Informatica can use.
  6. • Example: Extracting data from an Oracle database and converting it into a row set that Informatica can process.
  7. 2. Expression Transformation
  8. • Purpose: Performs row-wise calculations or transformations.
  9. • Example: Calculating the total price of an order by multiplying the quantity by the unit price. Informatica Training Institutes in Hyderabad
  10. 3. Aggregator Transformation
  11. • Purpose: Performs aggregate calculations, such as sums, averages, counts, etc.
  12. • Example: Calculating the total sales amount per region.
  13. 4. Filter Transformation
  14. • Purpose: Filters rows based on a specified condition.
  15. • Example: Selecting records where the sales amount is greater than $1000.
  16. 5. Joiner Transformation
  17. • Purpose: Joins data from two heterogeneous sources based on a join condition.
  18. • Example: Joining customer data from an SQL Server database with sales data from an Oracle database.
  19. 6. Lookup Transformation
  20. • Purpose: Looks up data in a relational table, view, or synonym.
  21. • Example: Looking up the current address of a customer from a reference table using customer ID.
  22. 7. Sorter Transformation
  23. • Purpose: Sorts data in ascending or descending order based on specified columns.
  24. • Example: Sorting employee data by employee ID in ascending order.
  25. 8. Router Transformation
  26. • Purpose: Routes data into multiple groups based on specified conditions.
  27. • Example: Routing sales data into different groups based on region.
  28. 9. Union Transformation
  29. • Purpose: Combines data from multiple pipelines into a single pipeline.
  30. • Example: Combining sales data from multiple regions into a single dataset.
  31. 10. Update Strategy Transformation
  32. • Purpose: Determines how to handle updates to data in the target.
  33. • Example: Flagging records for insertion, update, deletion, or rejection based on business logic. Informatica Cloud Data Integration Training
  34. 11. Sequence Generator Transformation
  35. • Purpose: Generates unique numeric values.
  36. • Example: Generating unique invoice numbers for sales transactions.
  37. 12. Stored Procedure Transformation
  38. • Purpose: Calls and executes a stored procedure in a database.
  39. • Example: Executing a stored procedure to update inventory levels after processing a sales order.
  40. 13. Transaction Control Transformation
  41. • Purpose: Defines transaction boundaries within a session.
  42. • Example: Committing data to the target after processing a certain number of rows.
  43. 14. Rank Transformation
  44. • Purpose: Select the top or bottom-ranked data.
  45. • Example: Identifying the top 10 salespersons based on sales amount.
  46. 15. Normalizer Transformation
  47. • Purpose: Converts denormalized data to a normalized format.
  48. • Example: Converting a single row with multiple repeating columns into multiple rows.
  49. 16. XML Source Qualifier Transformation
  50. • Purpose: Processes XML data from XML sources.
  51. • Example: Extracting and transforming customer data from an XML file.
  52. 17. SQL Transformation
  53. • Purpose: Executes SQL queries against a database.
  54. • Example: Performing a complex SQL join operation on two tables and integrating the result into the data flow. Informatica Cloud Online Training
  55. 18. Union Transformation
  56. • Purpose: Combines data from multiple sources into a single pipeline.
  57. • Example: Merging employee data from different departments into a single dataset.
  58. 19. Java Transformation
  59. • Purpose: Executes custom Java code within a mapping.
  60. • Example: Implementing complex business logic that is easier to code in Java than using Informatica expressions.
  61. 20. Python Transformation
  62. • Purpose: Executes custom Python scripts within a mapping.
  63. • Example: Performing advanced data analytics and machine learning operations.
  64. Conclusion
  65. Informatica transformations are powerful tools for manipulating and managing data during the ETL process. They allow for complex data integration tasks to be handled efficiently and effectively, ensuring that data is processed, cleaned, and transformed according to business requirements. Understanding and utilizing these transformations can significantly enhance the capabilities of data integration workflows. IICS Training in Hyderabad
  66. Visualpath is the Best Software Online Training Institute in Hyderabad. Avail complete Informatica Cloud worldwide. You will get the best course at an affordable cost.
  67. Attend Free Demo
  68. Call on - +91-9989971070.
  69. WhatsApp: https://www.whatsapp.com/catalog/919989971070
  70. Blog Visit: https://visualpathblogs.com/
  71. Visit https://www.visualpath.in/informatica-cloud-training.html
comments powered by Disqus