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 |
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
I have 1200 records how can u send it in aggregator with good performance issues?
What is the exact difference b/w IN and EXIST in Oracle..?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
What is the format of informatica objects in a repository?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Sequence generator, when you move from develoment to production how will you reset
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
How do you set a varible in incremental aggregation