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...

my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?

Answer Posted / vidyasagar

just use the below query in SQ override:)

select * from table

union all

select * from table

Regards:
Vidyasagar

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete duplicate row using informatica?

1033


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1787


What all are steps in up gradation of Informatica server?

1043


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2177


How can you generate reports in informatica?

1023


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2278


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1289


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1577


Clarify the utilization of aggregator cache record?

991


What do you mean incremental aggregation?

1072


Enlist the differences between database and data warehouse.

1115


Tell me about Propagate functions in informatica

917


define galaxy repository in informatica

2220


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10677


Can you generate sequence numbers without using the sequence generator transformation?

1117