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

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  


Explain lookup transformation in informatica

0 Answers   Informatica,


What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,


what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,


What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  






What is the command used to run a batch?

0 Answers  


Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,


Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,


What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,


What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,


Categories