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
- 15629 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 |
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is flat file override?
How to load the data from people soft hrm to people soft erm using informatica?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
What does reusable transformation mean?
While importing the relational source defintion from database,what are the meta data of source U import?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Explain the flow of data in Iinformatica?
need for registering a repository server
Explain informatica architecture - version 8 / 9
Under which circumstances, informatica server creates reject files?
Teradata 
