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

Answer / amulya kumar panda

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

Answer / guest

while before running the job it ask stop incoming rows and
warnings thete we to mention number of records

Can you explain players in datastage?

0 Answers  

---

What is process model?

0 Answers  

---

What are the benefits of datastage?

0 Answers  

---

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

---

which r the connectors used in san?

0 Answers  

---

client know skid info?

0 Answers   NTT Data,

---

what is the use of surogate key in datastage

3 Answers  

---

What is a quality stage?

1 Answers  

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

---

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

---