Which is costliest transformation? costly means occupying
more memory?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between STOP and ABORT options in Workflow Monitor?

802


What is the reusable transformation?

735


4 yrs etl devloper roles and responsibilities?any body give solutions

1690


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

817


What are the guidelines to be followed while using union transformation?

742






What does cheating measurement mean?

684


Have you worked with/created Parameter file

1316


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1556


what is size of u r database?

1942


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6720


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1725


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

706


How to generate sequence numbers using expression transformation?

729


In informatics server which files are created during the session rums?

731


What are the differences between source qualifier and joiner transformation?

683