performance wise which one is better in joiner and lookup transformation?why?explain clearly?

Answer Posted / soujanya

before cache joiner after cache lookup

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

625


How do you handle two sessions in Informatica

676


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1063


wf dont have integration severances how you can run?

1547


What is the use of code page?

617






What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1666


What are multi-group transformations?

573


What are the features of complex mapping?

656


What differs when we choose the sorted input for aggregator transformation?

578


What is a rank transform?

684


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

647


Briefly define a session task?

599


What is the difference between a connected look up and unconnected lookup?

582


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

1706


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

6415