Interested to Buy Any Domain ? << Click Here >> for more details...
how to connect two or more table with single source qualifier?
- 4 Answers
- 20780 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rampriya
Create a Oracle source with how much ever column you want
and write the join query in SQL query override. But the
column order and data type should be same as in the SQL query.
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is decode in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the types of schemas we have in data warehouse.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the need of etl tools?
Why filter transformation is an active one?
Explain constraint based loading in informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the different lookup cache(s)?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define pmcmd command?
What is a sequence generator transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
