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 |
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
What is event and what are the tasks related to it?
To achieve the session partition what r the necessary tasks u have to do?
How Union Transformation is an Active Trans?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
hw cn v elimate dublicate values from lookup without overriding sql?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
how to declare array in plsql?
8.what is mapplet ?give example?
Explain lookup transformation source types in informatica