can we use cartesian join in informatica

Answer Posted / rajesh

yes we can ,by creating dummy ports in expression transmission like forjoin and tojoin ,in joiner transformation condition is forjoin=tojoin and output is m*n format

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different versions of informatica?

655


Design a mapping to load a target table with the following values from the above source?

874


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5250


What are the different clients of powercenter?

599


What is pmcmd command?

677






How many dimensions are there in informatica?

626


What is rank transform?

601


What is a router transformation?

628


What is the difference between a repository server and a powerhouse?

809


How are indexes created after completing the load process?

987


How many number of sessions can one group in batches?

691


What is the need of an ETL tool?

642


What is a connected transformation?

674


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1675


How can we use batches?

604