How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 13864 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishore
Very Simple guys....
Do a Override in SQ:
Select * from Tab1, Tab2
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / lokesh
Manually add dummy cols to both table with same data type and join dem with joiner transformation
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kalyan
Option 1:
Drag both the sources to an expression. Hardcord a new
field say NEW_VALUE=1, in both the expressions.
Now join both these pipelines using the joiner with join
condition on the new_field you havecreated(NEW VALUE)
Option 2:
How abt using a full outer join as the type of join in the
joiner Transformation...
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / niroshreddy@gmail.com
hello hero's dont send wrong answers ..................
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramz
use Cartesian product or cross join
select required columns from tab1,tab2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / developer
use a union transformation if there are no matching ports.
| Is This Answer Correct ? | 0 Yes | 5 No |
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
How can you change from reusable session into non-reusable session.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Which is the best place to learn Informatica Powercenter Online Training?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
what is the main advantage of unconnected lookup
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
Explain joiner transformation in informatica
Define maping and sessions?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
Teradata 
