Interested to Buy Any Domain ? << Click Here >> for more details...
how to closeing records after 10,000 records come?
- 3 Answers
- 6388 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
-->If the Source is File:
"Read First Rows"=10000 --> Only read the first specified number of rows from each file.
"Filter"= sed -n '1,10000 P' or head -10000: we can use UNIX commands to filter the data.
-->If source is DB:
Oracle: where rownum<=10000
DB2: sample 10000 row only
Teradata: fetch first 10000 rows only
-->In Transformer:
We can use @INROWNUM<=10000 system variable
We can use Stage variables and count the values and in the contraints part use Stage_Var<=10000
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / amulya kumar panda
In transformer stage has system variable and select
@INROWNUM <10000
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
while before running the job it ask stop incoming rows and
warnings thete we to mention number of records
| Is This Answer Correct ? | 0 Yes | 3 No |
how do u reduce warnings
how can we create tables in datastage?
What are some prerequisites for datastage?
how can i abort the job if i get more than 100 errors in job log?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
What is meta stage?
If the job aborted in a sequencer, how can we start that from the previews successful job.
How many types of stage?
What are the repository tables in datastage?
What are the benefits of datastage?
plz tell me some dimentional and fact table names in banking project?
What is a merge?
Teradata 
