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
How to elaborate powercenter integration service?
What do you mean by blocking transformation?
Global and Local shortcuts. Advantages.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Briefly describe lookup transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
how to create user defined function (udf) in informatica
What is the use of an aggregator cache file?
How to do unit testing in informatica? How to load data in informatica ?
When do you use sql override in a lookup transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
How to start a workflow using pmcmd command?
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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the meaning of up gradation of repository?
