how to connect two or more table with single source qualifier?
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
Explain scd type 3 through mapping.
Write the different tools in the workflow manager?
How would you join a node to the already existing domain?
How do you convert single row from source into three rows into target?
Is stop and abort are same in informatica?
How do you handle two sessions in Informatica
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the difference between writing a joiner query in ANSI style and THETA style?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
In informatics server which files are created during the session rums?
differences between service based and product based?
Can we create a node as a gateway node and the same node can be assigned to a grid?
write a query to retrieve the latest records from the table sorted by version(scd)
What is a node in Informatica?
What is resilience time?