Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how to closeing records after 10,000 records come?

Answers were Sorted based on User's Feedback



how to closeing records after 10,000 records come?..

Answer / subbuchamala

-->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

how to closeing records after 10,000 records come?..

Answer / amulya kumar panda

In transformer stage has system variable and select
@INROWNUM <10000

Is This Answer Correct ?    0 Yes 0 No

how to closeing records after 10,000 records come?..

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

Post New Answer

More Data Stage Interview Questions

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,


Difference between data warehousing and olap?

0 Answers  


what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,


in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,


How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,


how to find diff between 2 dates without using Icon... funtions?

1 Answers  


In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,


what about data stage requirement

1 Answers  


Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  


Define meta stage?

0 Answers  


1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,


what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,


Categories