What are the basic needs to join two sources in a source
qualifier?
Answer Posted / 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 |
Post New Answer View All Answers
What is the status code in stored procedure transformation?
What is Index Caches size?
How can we remove the duplicates from flat file source?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Under what condition selecting sorted input in aggregator may fail the session?
How can you validate all mappings in the repository simultaneously?
Explain how to import oracle sequence into informatica?
scenario where i can use only concurrent execution of workflow.
Can you generate sequence numbers without using the sequence generator transformation?
How can we update a record in the target table without using update strategy?
Informatica settings are available in which file?
How can informatica be used for an organization?
What is sequence generator transformation in informatica?