Source qualifier transformation is used to represent rows that Integration service reads in a session. It is an active transformation. Using source qualifier, the following tasks can be fulfilled: 1. When two tables from the same source database with primary key – foreign key transformation relationship is there, then the sources can be linked to one source qualifier transformation. 2. Filtering rows when Integration service adds a where clause to the user's default query. 3. When a user wants an outer join instead of an inner join, then join information is replaced by metadata specified in SQL query. 4. When sorted ports are specified, the integration service uses the order by clause to the default query. 5. If a user chooses to find a distinct value, then integration service uses select distinct to the specified query. When the data we need to filter is not a relational source, the user should use Filter transformation. It helps the user to meet the specified filter condition to let go or pass through.
When for some tables, this is not possible, then a user can create a stored procedure and then join the tables in the database. 2. Data should be sorted before applying to join whenever possible. 3. When data is unsorted, then a source with fewer rows should be considered a master source. 4. For sorted joiner transformation, a source with less duplicate key values should be considered a master source. Recommended Article This has been a guide to List of Informatica Scenario Based Interview Questions and answers so that the candidate can crackdown these Interview Questions easily. You may also look at the following articles to learn more – Maven Interview Questions and Answers | Top And Most Asked 10 Advanced AngularJS Interview Questions for Experienced Guide to Informatica ETL Tools 12 Most Awesome Selenium Interview Questions And Answer Amazing Guide to Informatica Architecture Complete Guide to Informatica vs Datastage
What are some scenario based, logical questions that are asked in a Business Analyst interview? - Quora
A new output port should be created as O_total_records in the aggregator and assign O_count port to it. The aggregator will return the last row. This step's final output will have a dummy port with value as 1 and O_total_records will have a total number of records in the source. The aggregator output will be: O_total_records, Dummy_output 5 1 Step 3: Pass this output to joiner transformation and apply a join on dummy port. The property sorted input should be checked in joiner transformation. Only then the user can connect both expression and aggregator transformation to joiner transformation.