Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is informatica file watch timers in aflat i want to get the first record and last record how?




448
views
asked marvit September 20, 2014 08:01 AM  

What is informatica file watch timers in aflat i want to get the first record and last record how?


           

1 Answers



 
answered By vishnoiprem   0  
1) use the first and last functions of aggregate t/tion.
2) use the top option and 1 rank using rank t/tion
similarly last option and 1 rank to get only the first and last records.
3) else connect the flat file to filter t/tion. create new
port in filter name it s_no and connect the nextval port of sequence gen and write the contion (assume the file contains 100
records) like s_no=1 or s_no=100
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert