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
- 9029 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 are the settings that you use to configure the joiner transformation?
How do you use reject loader.
4 yrs etl devloper roles and responsibilities?any body give solutions
How would you copy the content of one repository to another repository?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How can you validate all mappings in the repository simultaneously?
Define Pmrep command?
In informatica workflow manager, how many repositories can be created?
Can we override a native sql query within informatica?
What is flashback table ? Advance thanks
How does a rank transform differ from aggregator transform functions max and min?
Explain joiner transformation in informatica
Explain sql transformation in script mode examples in informatica
