Which is costliest transformation? costly means occupying
more memory?

Answers were Sorted based on User's Feedback



Which is costliest transformation? costly means occupying more memory?..

Answer / srinu

Look up Transformatoin only,
its going to maintain existing data also in cach memory

Is This Answer Correct ?    7 Yes 0 No

Which is costliest transformation? costly means occupying more memory?..

Answer / subhransu,bangalore

costly means consuming more memory.which transformation have cache memory.
example:lookup TR
sorter TR
aggregator TR
rank TR
joiner TR

Is This Answer Correct ?    2 Yes 0 No

Which is costliest transformation? costly means occupying more memory?..

Answer / soujanya

costliest means occupying more memory.
filter
sorter
aggregator
rank
lookup
the transformations having cache memory

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

What are events in workflow manager?

1 Answers   Accenture, IBM,


if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,


we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  


Can we create two repositories on same database instance in oracle?

0 Answers  


What are the different components of powercenter?

0 Answers  






What are roles and groups and benefits of using them?

0 Answers  


Can we override a native sql query within informatica?

0 Answers  


How do you convert single row from source into three rows into target?

0 Answers  


Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  


What are the restrictions of union transformation?

0 Answers  


Why filter transformation is an active one?

0 Answers  


How do you load only null records into target? Explain through mapping flow.

0 Answers  


Categories