What are the basic needs to join two sources in a source
qualifier?
Answers were Sorted based on User's Feedback
Answer / sameer
1) Both sources should be from same Database.
2) They should have a common field which can be used for a
join.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / krishna
1. two sources must be from same datbase.
2.there should be primary-foreign key relationship between
them.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ravi
1) both tables should have PK-FK relationship
2) both should have matching datatypes.
| Is This Answer Correct ? | 4 Yes | 2 No |
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
what is difference between COM & DCOM?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is xml source qualifier transformation in informatica?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
What are variable ports and list two situations when they can be used?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What are the challenges you have faced in your project?
When do you use mapping parameters? (In which transformations)
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
how to use incremental load?