how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.

Answer Posted / murthy

use oracle join in SQL override

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what happens if the info.server doesn't find the session parameter in the parameter file?

1551


Explain about round-robi?

629


what is a worklet?

554


what is dynamic insert?

1718


what are the session parameters? How do u set them?

1522






Explain about power designer data modeling software?

475


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2066


how to load the data to fact table?

2163


where are the log files generally stored.Can you change the path of the file.what can the path be?

1938


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1661


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1385


Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

1814


What are the etl testing operations includes?

593


how do u handle performance issues in Informatica . where can u monitor the performance ?

4278


can cubes contain measures ?

1653