source file contains 100 records, i want 10 records in
target file how it possible in datastage

Answer Posted / rajesh

Hi This is Rajesh...By using Tail also we can get last 10 records

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between account and directory options ?

623


Define data aggregation?

671


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

2746


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3315


What can we do with datastage director?

675






What are the types of hashed files in data stage

646


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2429


What are the different options associated with dsjob command?

946


What are the stages in datastage?

639


Explain datastage architecture?

820


how to abort the job its matain duplicates?

2109


Can you explain tagbatch restructure operator?

705


Could anyone give brief explanation bout datastage admin

1973


Can you explain how could anyone drop the index before loading the data in target in datastage?

896


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2735