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
- 16118 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 to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
where to select code page option?
what are the perameter and variable?
What is difference between partioning of relatonal target and partitioning of file targets?
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
Can anyone tell me the new features in Informatica 9 Version?
how do u tune queries?
can we use bulk loading when we use look in mapping
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
I have source like this 1:2;3. so i want to load the target as 123
Teradata 
