How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 13884 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 |
What are the tasks that can be performed using sq?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
Plz..let me know differences between Informatica 7.1 and 8.1?
what is parallel querying and what r hints.
Can any body tell about the (UTC) unit test cases with the examples in informatica.
Whatis the difference between View and Materialized View ?
What could be the possible resons of locks by user?
can you use flat file for repository?why?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is an aggregator transformation? it is active why cant it be passive explain?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
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?
Teradata 
