INTERVIEW QUESTIONS DATA WAREHOUSING DETAILS

Question: I wanted to load only particular no of records suppose i have 100 records out of which i wanted to load first 10 records to target.

Answer: Select only 10 records in your source qualifier query.
You can use rownum function in oracle to select 10 records.

Select only 10 records in your source qualifier query.
You can use rownum function in oracle to select 10 records. Source: CoolInterview.com

For top or bottom 10 records or else specified number of records you can use Rank transformation. Source: CoolInterview.com

You can filter the records right in source qualifier via a query with condtion as rownum<=10

You can use a sequence generater and filter pair. sequence generater would cycle the count from 1 everytime and as soon as 10 reaches, filter transformation would reject the records.

You can use a variable port for counting purpose and then use a filter to drop rows from flow as soon as count reaches to 10. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question