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
- 9219 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
How do you use reject loader.
Can we get 1st record through Informatica(without sequence number).
Why update strategy and union transformations are active?
What are the different ways to implement parallel processing in informatica?
How does a rank transform differ from aggregator transform functions max and min?
Quickly characterize reusable change?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Define the various join types of joiner transformation?
What is olap (on-line analytical processing?
What is data movement mode in Informatica and difference between them?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to Create a folder using pmrep command?
Explain the difference between mapping parameter and mapping variable?
What is data transformation manager process?
How do you manage the Parameter files while migrating your data from one environment to another environment?
