Interested to Buy Any Domain ? << Click Here >> for more details...
wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 8932 Views
- CTS, I also Faced
- E-Mail Answers
Answer / bsgsr
i believe this should work.
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 lst 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
s.gen and write the contion (assume the file contains 100
records) like s_no=1 or s_no=100
| Is This Answer Correct ? | 5 Yes | 1 No |
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
Explain sessions. Explain how batches are used to combine executions?
How to load time dimension?
What differs when we choose the sorted input for aggregator transformation?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
How can yoU create or import flat file definition in to the warehouse designer?
what is the diff b/w cached and unchaed look ups
What do mean by local and global repository?
What are the reusable transforamtions?
How can we remove the duplicates from flat file source?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
Teradata 
