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
In how many ways we can create ports?
What is a pre-defined event and user-defined event?
What is a transaction control transformation?
What is a snowflake schema?
What is an Integration service in Informatica?
Describe an informatica powercenter?
How can we create index after completion of load process?
What is a joiner transformation and why it is an active one?
How many types of sessions are there in informatica.please explain them?
What is the need of etl tools?
What does reusable transformation mean?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the different types of repositories created using informatica?
I have a flat file, want to reverse the contents of the flat file