if i am having 10 records in source, i want 20 records in
target...how will you do it
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
How do we call shell scripts from informatica?
What is the use of target designer?
Explain why we use partitioning the session in informatica?
Did u used latest transformations of 8.6.0? for what?
lookup transformation with screenshots
Write the advantages of partitioning a session?
Does an informatica transformation support only aggregate expressions?
What are mapplets? How is it different from a Reusable Transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
where to store informatica rejected data? How to extract the informatica rejected data?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How you can differentiate between connected lookup and unconnected lookup?
How can we store previous session logs?
Write the unconnected lookup syntax and how to return more than one column.