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?
Answers were Sorted based on User's Feedback
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 many dimentions and fact tables used in your project and what are names of it?
what is the main differences between Lookup, Join and Merge stages?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
which is the most complex job in your career? Please tell me answer?
What is the difference between Link collector and Funnel Stages?
how to define satge variables in transformer stage
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
How to implement complex jobs in data stage?
Unix command to view the data in a dataset
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
How to Convert a string function to date function by using only sequential file stage with out using other stages ?