How to jion 2 tables, without using any condition?

Answer Posted / raj

Add dummy column in expression or Source Qul. for both
source and use that column in join condition.

Is This Answer Correct ?    12 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between joiner and lookup transformation?

618


How do you update the records with or without using update strategy?

664


What all join we can perform in LOOKUP transformation?

567


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1652


What is the different lookup cache(s)?

614






What is source qualifier transformation in informatica?

575


what is INFORMATICA TESTING process

1843


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

556


COM components can be used in Informatica

1875


How do you load unique records into one target table and duplicate records into a different target table?

712


What is rank transform?

603


What happens when a session fails and you click on recover?

657


How to generate sequence numbers?

618


Performance tuning( what you did in performance tuning)

1489


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1788