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
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is decode in static cache?
Explain constraint based loading in informatica
What are Dimensional table?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the function of union transformation?
Describe data concatenation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain load alternative records / rows into multiple targets - informatica
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain about Informatica server process that how it works relates to mapping variables?
Explain the difference between mapping parameter and mapping variable?
What are the components of the workflow manager?