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
- 11394 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 |
what is bitmap index? did u use it?and how to use it in informatica
What are the differences between source qualifier and joiner transformation?
Why sorter is an active transformation?
Differentiate between Load Manager and DTM?
How to fix the etl bugs..Tell me the process?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
What is the difference Between Mapping parameter and variable
what is constraint based load order
What is pmcmd command?
What are the reusable transforamtions?
tell me 7.x and 8.x diferrencess(but not transformations)
Design a mapping to load the cumulative sum of salaries of employees into target table?
Teradata 
