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
- 9039 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 |
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
what is the Default Source Option For Update Strategy Transformation?
I have 1200 records how can u send it in aggregator with good performance issues?
What is Java Transformation? what are the uses of it?
Major difference between SQL override and Lookup Sql override
Why filter transformation is an active one?
What is difference macros and prompts?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
What is active and passive transformation?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
Global and Local shortcuts. Advantages.
Teradata 
