Answer / vamsi

take source --->trf---->trg
in transformer constaints put inrownum <=10
then u can get the required answer.........

Answer / rajesh

Hi This is Rajesh...By using Tail also we can get last 10 records

Answer / alok

At source stage properties (I'm assuming Sequential File Stage is used), go to the Filter option in properties tab and type head -10. The sq file stage will read only top 10 records and ignore the rest.

Answer / radha guntupalli

If you want top ten records In seq file_options_filter-
head -10.For last 10 records tail -10.

Answer / snehasis

By using read first rows option in sequential file stage we can get 10 records out of 100 records of a file

Answer / chandu

while running prompt put 10 rows.

then the job terminates after 10rows in target

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

0 Answers   IBM,

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,

What is the purpose of pivot stage?

0 Answers  

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

Whats difference betweeen operational data stage (ods) and data warehouse?

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,

how does work server jobs?

1 Answers  

Explain ibm infosphere information server and highlight its main features?

0 Answers  

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,