Interested to Buy Any Domain ? << Click Here >> for more details...
i have two source data there is no pk,fk how to join the
two sources
- 5 Answers
- 11404 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandranmca2007
We can create a a dummy columns for both tables using that
dummy column we can join the both tables. If the both
tables have same column means we can using that join the
both tables.
If I wrong please send the answer to my mail id
chandranmca2007@gmail.com
| Is This Answer Correct ? | 21 Yes | 6 No |
Answer / tauseef
if the two sources or coming from same datasource then we
can use source Qualifier trans to join
if it is coming from different then same add a dummy port on both the tables and join
if its wrong send me the soulution to my id tauseefwst@yahoo.com
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ash
use joiner and create 2 ports in jnr and assign the default value 1 to each of the ports.
make sure that 1 port is master port and [ the other post is detail]. Now give the condition as new-masterport=new_detailsport.
This will give the cartesian product type of join.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / prathap
if the two sources or coming from different sources then we
use joiner transformation and add a dummy prot
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chandrababu.sarupuru
To join these sources we will use SQL Override function in
Source qlalifier transformation....
| Is This Answer Correct ? | 0 Yes | 4 No |
difference between source based commit? and target based commit? which is better with respect to performance?
what are presession,postsession success and postsession failure commands ?
Different qualification between a related rotate toward the sky and isolates look upward?
What are teh different tasks that can be created in workflow manager?
What is event and what are the tasks related to it?
what is index?how it can work in informatica
What is Java Transformation? what are the uses of it?
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
can we load the data with out a primary key of a table? what is target plan?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
differences between service based and product based?
Teradata 
