i have two source data there is no pk,fk how to join the
two sources
- 5 Answers
- 9674 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 |
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
what are the types of facts with Examples?
What is blocking transformation?
Describe an informatica powercenter?
what is the difference between Informatica7.1 & informatica 8.1
Explain pushdown optimization $pushdownconfig parameter - informatica
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
In informatics server which files are created during the session rums?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
What is a difference between complete, stop and abort?
Teradata 
