Interested to Buy Any Domain ? << Click Here >> for more details...
can we use cartesian join in informatica
- 3 Answers
- 8587 Views
- IBM, I also Faced
- E-Mail Answers
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 |
without update strategy how to insert &update?
What is factless fact schema?
Describe an informatica powercenter?
How to handle changing source file counts in a mapping?
Do you find any difficulty while working with flat files as source and target?
How mapping parameter and variable works
If I have a index defined on target table and if set it to bulk load will it work ?
Which is better performance wise database or file?How?
How will you update the first four rows and insert next four rows in a mapping?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the challenges of Dataware housing in the future?
Teradata 
