i have two source data there is no pk,fk how to join the
two sources
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 |
Suppose we do not group by on any ports of the aggregator what will be the output?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to delete duplicate records in a flat file source?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
what is hash table in informatica?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
What is a surrogate key?Why we use it in a mapping?Pl give an example.
what r the transformations that r not involved in mapplet?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
what is galaxy repository?
How do you do error handling in Informatica?