can we use cartesian join in informatica
- 3 Answers
- 7945 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 |
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
How can you join two tables without any common column present in them?
What is option by which we can run all the sessions in a batch simultaneously?
How to improve the performance of a session using sorter transformation?
What is difference between Mapplet and reusable transformation?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
How are indexes created after completing the load process?
Define error Threshold?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
where to store informatica rejected data? How to extract the informatica rejected data?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
As union transformation gives UNION ALL output, how you will get the UNION output?
Teradata 
