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 to load last n records of file into target table - informatica
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Mention few power centre client applications with their basic purpose?
What is a joiner transformation and why it is an active one?
How to extract the informatica rejected data?
How to partition the Session?
pmscmd startworkflow -sv
How union transformation is used?
In informatica workflow manager, how many repositories can be created?
what is Active lock explain
Explain direct and indirect flat file loading (source file type) - informatica
What is a predefined event?
can anyone explain me about retail domain project in informatica?
What is lookup transformation?
What is data movement mode in Informatica and difference between them?