Answer Posted / swap
You can write UNION ALL query in source qualifier
eg:-select NAME,EMP_ID from EMPLOYEE
UNION ALL
SELECT NAME,EMP_ID FROM EMPLOYEE
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain sessions and how many types of sessions are there?
How might one distinguish in the case of mapping is right or not without associating session?
What are the new features of informatica 9.x developer?
What is a joiner transformation?
What is persistent lookup cache?
What is session task and command task?
How can repository reports be accessed without sql or other transformations?
What is update strategy transform?
define galaxy repository in informatica
What is transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What's the layout of parameter file (what does a parameter file contain?)?
What is domain in terms of informatica?
Difference between Target-based loading and constraint-based loading?