Answer Posted / hari
. Aggregator Transformations
. Sorter Transformations
. Custom Transformation
. External Procedure Transformation
. Filter Transformation
. HTTP Transformation
. Java Transformation
. Joiner Transformation
. Lookup Transformation
. Normalizer Transformation
. Rank Transformation
. Router Transformation
. Sequence Generator Transformation
. Expression Transformation
. Sorter Transformation
. Source Qualifier Transformation
. SQL Transformation
. Stored Procedure Transformation
. Transaction Control Transformation
. Union Transformation
| Is This Answer Correct ? | 27 Yes | 4 No |
Post New Answer View All Answers
What is option by which we can run all the sessions in a batch simultaneously?
Define the various join types of joiner transformation?
Name the different lookup cache(s)?
What is dimensional table? Explain the different dimensions.
How many numbers of sessions can one group in batches?
What is expression transformation?
What is the need for an etl tool?
Quickly characterize reusable change?
What is the scenario which compels informatica server to reject files?
What are the differences between joiner transformation and source qualifier transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain lookup transformation in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Where is metadata stored?