source file contains 100 records, i want 10 records in
target file how it possible in datastage
Answer Posted / radha guntupalli
If you want top ten records In seq file_options_filter-
head -10.For last 10 records tail -10.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
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.
What are the functionalities of link collector?
Where do you see different stages in the designer?
Define data aggregation?
Explain datastage architecture?
How to implement complex jobs in data stage?
What are transforms and what is the differenece between routines and transforms?
Which commands are used to import and export the datastage jobs?
What is the precedence of stage variables,derivations, and constraints?
How a routine is called in datastage job?
What is the difference between operational data stage (ods) and data warehouse?
How do u convert the columns to rows in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how do u catch bad rows from OCI stage? And what CLI stands for?