how to closeing records after 10,000 records come?
- 3 Answers
- 5116 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 to reverse the string using SQL?
How can one find bugs in job sequence?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Demonstrate experience in maintaining quality process standards?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
how to handle null values using transformer stage?
what is factless fact table?
DataStage Scenario based Interview Questions
What is the difference between Link collector and Funnel Stages?
What are the different type of jobs in datastage?
What are the main features of datastage?
Teradata 
