how to connect two or more table with single source qualifier?
Answer Posted / tilak kumar dhar
We can use a Source Qualifier Transformation for this.
Perform the steps to achieve it:
1. Drag all the tables in Mapping Designer.
2. Delete all the source qualifiers associated with all the
tables.
3. Create a SQ transformation.
4. Drag all the columns from all the tables into the SQ
transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Which files are created during the session rums by informatics server?
What does cheating measurement mean?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How to join three sources using joiner? Explain though mapping flow.
Define mapplet?
Which version configuration tool used in ur project?
write a query to retrieve the latest records from the table sorted by version(scd)
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the types of presistent cache in look up tr.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How many ways are there to create ports?
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 ?