source file contains 100 records, i want 10 records in
target file how it possible in datastage
Answer Posted / snehasis
By using read first rows option in sequential file stage we can get 10 records out of 100 records of a file
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is the difference between hashfile and sequential file?
Can we use target hash file as a lookup ?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Explain Quality stage?
what is the use of materialized view?
What are transforms and what is the differenece between routines and transforms?
Lookup constraints
What is the difference between in process and inter process?
What is the difference between orabulk and bcp stages?
What is usage analysis in datastage?
What is size of a transaction and an array means in a datastage?
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 you need stage variables?
How one source columns or rows to be loaded in to two different tables?