Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

How to load last n records of file into target table - informatica

1066


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

2098


Mention few power centre client applications with their basic purpose?

942


What is a joiner transformation and why it is an active one?

1073


How to extract the informatica rejected data?

1217


How to partition the Session?

1107


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1506


How union transformation is used?

1002


In informatica workflow manager, how many repositories can be created?

1350


what is Active lock explain

2795


Explain direct and indirect flat file loading (source file type) - informatica

1318


What is a predefined event?

1087


can anyone explain me about retail domain project in informatica?

7944


What is lookup transformation?

1038


What is data movement mode in Informatica and difference between them?

1130