How can we read latest records in a text file named file1.txt using seq file s

How can we read latest records in a text file named
file1.txt using seq file stage only?

file1 having 100 records in that 5 record sare latest
records.How can we read that latest records?

Question Posted / sai

3 Answers
11940 Views
Caterpillar, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we read latest records in a text file named file1.txt using seq file stage only? file..

Answer / dileep j

Question is not clear... Be more specific.
As my asumption, the letest records might be the last 5 records in the Sequential file. If so...

In Sequential File stage,
In Filter option Give the Command "tail -5 File_name".

It will give last 5 records.

Correct me if I wrong ...

Is This Answer Correct ?

6 Yes

3 No

How can we read latest records in a text file named file1.txt using seq file stage only? file..

Answer / sriharsha vemuri

Use change Capture stage.

Is This Answer Correct ?

5 Yes

6 No

How can we read latest records in a text file named file1.txt using seq file stage only? file..

Answer / sai

by using seq file how we can?

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Data Stage Interview Questions

What is active and passive stage?

0 Answers

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers HCL,

why we use hash file for lookup?

5 Answers

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers Systime,

what is .dsx files

3 Answers IBM,

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers

how to do pergformence tuning in datastage?

4 Answers MCA, Symphony, TCS,

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers Syntel,

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers Cap Gemini, TCS,

I have a few records just I want to store each records tow times in target how?

2 Answers Polaris,

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000

5 Answers Genpact,

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers Amdocs,

For more Data Stage Interview Questions Click Here