Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic needs to join two sources in a source
qualifier?
- 4 Answers
- 13032 Views
- I also Faced
- E-Mail Answers
Answer Posted / bidhar
Sources should be Homogeneous.Though they might not have a
joining condition.
For Example If you have Employee table and Dept Table and
the joining condition is on deptid then its not mandatory
that you must specify the joining condition.If you dont
specify the joining condition then it will have a cartesian
join.
Also the Ports Serial should be same as the SQ override
select.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you load only null records into target?
write a query to retrieve the latest records from the table sorted by version(scd)
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Separate from an archive server and a powerhouse?
What are multi-group transformations?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Define enterprise data warehousing?
What is the reusable transformation?
what are the Methods For Creating Reusable Transformations?
Define filter transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain sql transformation in script mode examples in informatica
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are batches?
