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
- 8926 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a dimensional model?
What is a joiner transformation?
What is status code in informatica?
What are Dimensional table?
Does an informatica transformation support only aggregate expressions?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to use procedural logic inside infromatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Write the program through which the records can be updated?
Write the unconnected lookup syntax?
What is target load order?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Partition, what happens if the specified key range is shorter and longer
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How do you set a varible in incremental aggregation
