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

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,

---