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
- 15909 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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the difference between stop and abort in informatica
How to elaborate tracing level?
Suppose we do not group by on any ports of the aggregator what will be the output?
What happens when a session fails and you click on recover?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How would you copy the content of one repository to another repository?
What's the layout of parameter file (what does a parameter file contain?)?
Can anyone tell me the new features in Informatica 9 Version?
What is the reusable transformation?
What is data transformation manager process?
What are roles and groups and benefits of using them?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
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
What is a pre-defined event and user-defined event?
