How to load last n records of file into target table - informatica
- 1 Answers
- 1159 Views
- Informatica, I also Faced
- E-Mail Answers
Answer / Shailendra Chandra
To load the last 'n' records of a file into a target table, you can follow these steps:n
1. Use a Source Qualifier transformation and sort the data based on the desired column (usually a timestamp or sequence number).n
2. Add a Row Count transformation after the Source Qualifier to count the total number of rows.n
3. Use a Script transformation to subtract 'n' from the row count, and calculate the position of the last record you want to load.n
4. Use a Filter transformation to filter out all records before the calculated position.n
5. Finally, use a Target Qualifier transformation to map the filtered data to the target table columns and execute the mapping.
| Is This Answer Correct ? | 0 Yes | 0 No |
can you use flat file for lookup table?why?
how to obtain performance data for individual transformations.
how many session run unix environment what command using ?
How to recover the standalone session?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
Differentiate between sessions and batches?
what is the flow?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
Briefly describe lookup transformation?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
how do the project develops? pls specify right from the start to end in step by steps.
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
Teradata 
