Interested to Buy Any Domain ? << Click Here >> for more details...
How to find from a source which has 10,000 records, find the
average between 500th to 600th record?
- 3 Answers
- 9206 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishna
first u take the source,if it is flat file or relational
table then using exp t/r create one variable port.the port
like v.
increment the v value for every record .
after u write the condition in filter t/r v>=500 and v<=600
After use agg t/r and select the group by port as sal and
write the agg function avg(sal).After give the output that
port to target table
if it is relational table then use direct query in sql over
ride in source qualifier itself like
SELECT * FROM <TABLE NAME> WHERE ROWNUM>=500 AND
ROWNUM<=600
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Enlist the various types of transformations.
How to implement security measures using repository manager?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is joiner transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the main features of Oracle 8i with context to datawarehouse?
What are the new features of Power Center 5.0?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is a surrogate key?
Does an informatica transformation support only aggregate expressions?
What are the different types of repositories created using informatica?
What is workflow monitor?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
