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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we create index after completion of load process?

595


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1552


What are the prerequisite tasks to achieve the session partition?

709


Explain the shared cache and re-cache?

608


Explain what is informatica metadata and where is it stored?

605






Where are the source flat files kept before running the session?

623


What are the tuning techniques you applied during your last project

1559


list out all the transformations which use cache?

686


How to create a non-reusable instance of reusable transformations?

674


What is the function of look up transformation?

649


Separate from a database, an information bazaar, and an information stockroom?

605


What is rank transform?

595


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

612


What is main use of mapplet?

655


can anyone explain me about retail domain project in informatica?

7430