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
- 9017 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 |
Which gives the more performance when compare to fixed width and delimited file ? and why?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Can informatica load heterogeneous targets from heterogeneous sources?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
How to load last 10 records of flat file in to the target?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What is decode in informatica?
why sequence generator should not directly connected to joiner transformation ?
how to improve performence by using sorted input in aggrigator t/r.
What are the performance considerations when working with aggregator transformation?
in static and dynamic which one is better
Which is better performance wise database or file?How?
Teradata 
