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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1642


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2131


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3313


What is lookup transformation?

581


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

615






Where do we use mapping variables in informatica?

606


How to open an older version of an object in the workspace?

608


what is unit testing?tell me proceedure

1766


How do you promote a non-reusable transformation to reusable transformation?

656


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1863


Could you explain what is enterprise data warehouse?

547


scenario where i can use only concurrent execution of workflow.

2530


if we have a delimiters at unwanted places in a flat file how can we over come those.

1561


Tell me about Propagate functions in informatica

518


What are the conditions needed to improve the performance of informatica aggregator transformation?

577