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?
- 3 Answers
- 10335 Views
- Caterpillar, I also Faced
- E-Mail Answers
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 can we extract data with out having any common column
what is parameterset?
How to add zero "0" before record in a field?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
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
on how many columns we can perform aggregation in the aggregator stage?
what is the function in Transformer stage can act as Rank function in Oracle
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
How do u view log file for a particular job?
What could be a data source system?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
How to reverse the string using SQL?
Teradata 
