Interested to Buy Any Domain ? << Click Here >> for more details...
if i am having 10 records in source, i want 20 records in
target...how will you do it
- 13 Answers
- 18078 Views
- BirlaSoft, IBM, I also Faced
- E-Mail Answers
Answer Posted / gyana
pls friends try this..its easy and flexible
--------------------------------------------
SOURCE ---->SOURCE QUALIFIER------->TARGET
IN SQ WRIT THE SQL QUERY
------------------------
SELECT * FROM EMP
UNION ALL
SELECT * FROM EMP WHERE ROWNUM<11
PLS LET ME KNOW IF I AM WRONG
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
have u done any performance tuning? how u ll do?
In warehouses how many schemas are there?
wat are deployement groups in informatica, how it will be used for developers
Differentiate between sessions and batches?
difference between repository database and repository service?
Explain the mapping variable usage example in informatica
What are the differences between oltp and olap?
What is the benefit of partitioning a session?
What is meant by lookup transformation?
What are the main issues while working with flat files as source and as targets ?
What are the types of caches in lookup? Explain them.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is workflow manager?
What are the uses of etl tools?
What is the function of aggregator transformation?
