which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
Answer Posted / jyothiram
XML is costliest transformation after sorter.
XML--- 10 units
sorter---8 units
lkup,joiner,agg,rank-(index)-1 unit
lkup,joiner,agg,rank-(data)-2 unit
These are the order of costlier in cache making
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
How to elaborate powercenter integration service?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the types of schemas we have in data warehouse.
How to Create a folder using pmrep command?
What are the types of data warehouses?
Write the unconnected lookup syntax?
How is union transformation utilized?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Differentiate between joiner and lookup transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
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
How would you join a node to the already existing domain?
How many dimensions are there in informatica?