How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 13989 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
What's the layout of parameter file (what does a parameter file contain?)?
What are the different ways to implement parallel processing in informatica?
What do mean by local and global repository?
What is a stored procedure transformation?
Explain dynamic target flat file name generation in informatica
What is domain and gateway node?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Can we create a Integration service without a Repository service and vice versa?
What is source qualifier transformation in informatica?
What are the different options available for update strategy?
Is it possible to revert a global repository to local one and why?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is a connected transformation?
What is informatica?
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
