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
- 9087 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
How to update or delete the rows in a target, which do not have key fields?
What is a snowflake schema?
Explain what transformation and how many are there in informatica?
Can we get 1st record through Informatica(without sequence number).
Enlist the advantages of informatica.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is a repository? And how to add it in an informatica client?
Enlist few areas or real-time situations where informatica is required.
How can we use mapping variables in informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the use of source qualifier?
r u done any partitions in ur project?
In informatics server which files are created during the session rums?
What if the source is a flat-file?
