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
- 11256 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 |
How to delete duplicate records in a flat file source?
What is the difference between warehouse key and surrogate key?
how to get max value record into one target and remaining records into another target?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
What is a standalone command task?
What are partitions in informatica and which one is used for better performance?
How will you check the bottle necks in informatica? From where do you start checking?
What are the different types of repositories created using informatica?
Explain sessions. Explain how batches are used to combine executions?
How to merge First Name & Last Name?
What all join we can perform in LOOKUP transformation?
Teradata 
