Interested to Buy Any Domain ? << Click Here >> for more details...
how to closeing records after 10,000 records come?
- 3 Answers
- 6183 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 |
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
What's the Main Function of the Staging area in DWH
What are the different type of jobs in datastage?
How to add zero "0" before record in a field?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
which dim, fact tables used in bank domain
Whats difference betweeen operational data stage (ods) and data warehouse?
What is mapping?
Main Function of the Staging area in DWH ?
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Teradata 
