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 |
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
what is confirmed dimension?
Explain the code page compatibility?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain lookup transformation in informatica
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Separate from an archive server and a powerhouse?
Reusable transformation and shortcut differences
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
How many dimensions are there in informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?