can we use cartesian join in informatica

Answers were Sorted based on User's Feedback



can we use cartesian join in informatica..

Answer / raju

No we can,t use cartesian join in informatica

Is This Answer Correct ?    8 Yes 1 No

can we use cartesian join in informatica..

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

can we use cartesian join in informatica..

Answer / venkateshmalneni

we can use Cartesian join in informatica by using full outer
option in joiner t/r


if am wrong please let me know

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More Informatica Interview Questions

what is mapping optimization? wat are the techniques for tat

2 Answers  


2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,


I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,


What is a poling?

2 Answers  


Define maping and sessions?

3 Answers  






What is meant by LDAP users?

0 Answers  


While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  


 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,


explan ur project architecture?

0 Answers   TCS,


How many dimensions are there in informatica?

0 Answers  


what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,


Categories