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

There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this

Answer Posted / bharath

Use query
>select * from tab1,tab2;

You get Cartesian Product of two table rows
if tab1 having m no.of an tab2 has n no of col
then mXn (m by n) rows are returned.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define meta stage?

1259


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3214


What are the areas of application?

1197


On which Dimension Table you implemented SCD Type in your Project

2113


Name the third party tools that can be used in datastage?

1138


What is the difference between server job and parallel jobs?

1200


Differentiate between datastage and informatica?

1250


What are the some differences between 7.x and 8.x version of datastage?

1305


What a datastage macro?

1101


Can you explain kafka connector?

1378


Distinguish between informatica & datastage. Which one would you choose and why?

1043


What are some prerequisites for datastage?

1169


Describe the main features of datastage?

1125


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1554


What are the enhancements made in datastage 7.5 compare with 7.0?

1208