Interested to Buy Any Domain ? << Click Here >> for more details...
How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 16122 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyan
Option 1:
Drag both the sources to an expression. Hardcord a new
field say NEW_VALUE=1, in both the expressions.
Now join both these pipelines using the joiner with join
condition on the new_field you havecreated(NEW VALUE)
Option 2:
How abt using a full outer join as the type of join in the
joiner Transformation...
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Make a note of the quantity vaults made in informatica?
What is dynamic cache?
Can you generate sequence numbers without using the sequence generator transformation?
Which transformation is needed while using the Cobol sources as source definitions?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the surrogate key?
What is a joiner transformation?
How to create a non-reusable instance of reusable transformations?
What are the different types of transformation available in informatica.
What is the difference between a repository server and a powerhouse?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How are the sources and targets definitions imported in informatica designer?
In development project what is the process to follow for an etl developer from day1
Write the different tools in the workflow manager?
