can we use cartesian join in informatica
Answers were Sorted based on User's Feedback
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 |
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 |
what is mapping optimization? wat are the techniques for tat
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?
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..
What is a poling?
Define maping and sessions?
What is meant by LDAP users?
While migrating the data from one environment to another environment how would you manage the connections?
 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?
explan ur project architecture?
How many dimensions are there in informatica?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,