i have two source data there is no pk,fk how to join the
two sources

Answers were Sorted based on User's Feedback



i have two source data there is no pk,fk how to join the two sources..

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

i have two source data there is no pk,fk how to join the two sources..

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

i have two source data there is no pk,fk how to join the two sources..

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

i have two source data there is no pk,fk how to join the two sources..

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

i have two source data there is no pk,fk how to join the two sources..

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

Post New Answer

More Informatica Interview Questions

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  


What is the need for an etl tool?

0 Answers  






CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,


What are the joiner caches?

3 Answers   Informatica,


What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,


Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  


Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  


yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,


Explain the mapping variable usage example in informatica

0 Answers   Informatica,


Categories