by Dipali Chaudhari
What transformation is used to convert rows into columns?
How to convert rows into columns in Informatica? – Explained the example by using Expression transformation.
What are the difference between update and alter commands in SQL? Explained with uses of update and alter commands, syntax, function, example, operation, and commit role.
What are the difference between delete, drop and truncate in SQL? Explained delete vs truncate vs drop sql commands with the help of specifications, syntax, uses, and may more differences.
What are the different types of sql commands with examples? Explained 5 types of SQL commands- Data Query Language (DQL), Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL) and Transaction Control Language (TCL)
What are the difference between joiner and lookup transformation in Informatica? Which is better in performance joiner or lookup?
Can we use joiner instead of lookup?
What are the difference between source qualifier and joiner transformation in informatica? What are the use of source qualifier and joiner transformations in Informatica? Is joiner an active or passive transformation?
What are the difference between filter and router transformations in informatica? Why Router is better than filter? Is router transformation active or passive?
What are the difference between active and passive transformations in informatica? What are the active and passive transformations? What are the examples of active and passive transformations?
List of transformations in Informatica Power Center (IPC) & Informatica Integrated Cloud Service (IICS), Active or passive types of transformations.