how to closeing records after 10,000 records come?
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 |
what is snow flack schema?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
how to find no.of records in sequntial file itself?
what is data mapping
How many number of reject links merge stage can have?
Can you explain engine tier in information server?
What is RCP
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is a quality stage in datastage tool?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????