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 soource is having 10 records how will u insert 20
records to target

Answer Posted / sreekanth

select * from table_name
union all
select * from table_name;

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

tell me the rules and responsblites in our project(my project is development)

1918


Explain in detail about scd type 1 through mapping.

1426


What is the function of look up transformation?

1109


What is an Integration service in Informatica?

1117


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7016


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1911


How you know when to use a static cache and dynamic cache in lookup transformation?

1839


How many number of sessions can one group in batches?

1144


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1890


What is olap (on-line analytical processing?

1055


can anyone explain me about retail domain project in informatica?

7929


What is Index Caches size?

1095


What are mapplets? How is it different from a Reusable Transformation?

1072


Enlist the advantages of informatica.

1047


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2708