Interested to Buy Any Domain ? << Click Here >> for more details...
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 is deployment group?
Explain lookup transformation is active in informatica
How to join three sources using joiner? Explain though mapping flow.
what are the Methods For Creating Reusable Transformations?
what are 3 tech challenges/ common issues you face?
How we can create indexes after completing the loan process?
How do you promote a non-reusable transformation to reusable transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
how to load rows into fact table in data warehouse
What you know about transaction control transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How do you update the records with or without using update strategy?
Repository user profiles
What is informatica etl tool?
