Interested to Buy Any Domain ? << Click Here >> for more details...
How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 15619 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 |
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
Separate from a database, an information bazaar, and an information stockroom?
How to do unit testing in informatica?
why we use materialized view over view?
any body can say about all versions of informatica ?how many versions ?
performance tuning of Informatica
can we override a native sql query within informatica? How do we do it?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
To achieve the session partition what r the necessary tasks u have to do?
Explain how many types of dimensions are available in informatica?
Teradata 
