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
- 15630 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
can we override a native sql query within informatica? Where do we do it?
What is dynamic cache?
What is a filter transformation and why it is an active one?
In development project what is the process to follow for an etl developer from day1
How might you approve all mappings in the archive all the while?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
difference between repository database and repository service?
Why do you use Mapping Parameter and mapping variable?
What is a sorter transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
tell me about your project functionality
Can we create a Integration service without a Repository service and vice versa?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to delete duplicate row using informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
