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
What is quality stage?
client know skid info?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
explain about citrix scheduling tool in datastage
Is possible to create skid in dim,fact tables?
What are routines in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Define oconv () and iconv () functions in datastage?
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.
What is datastage engine?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
why do u need the IOS upgradation in a FC switch
What is the difference between orabulk and bcp stages?
What are the components of ascential data stage?
What are routines in datastage? Enlist various types of routines.