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
- 11593 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 |
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the exact difference b/w IN and EXIST in Oracle..?
What is data merging,data cleansing,sampling?
What is up date strategy and what are the options for update strategy?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
how do u move the code from development to production?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
In any project how many mappings they will use(minimum)?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
How can you run a session without using server manager?
Teradata 
