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
- 9334 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
Why sorter is an active transformation?
design of staging area?
What are the types of caches in lookup?
What is a joiner transformation?
What is complex mapping?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Which files are created during the session rums by informatics server?
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?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is a stored procedure transformation?
what is mean by complex business rule ?
Can anyone tell me the new features in Informatica 9 Version?
Describe data concatenation?
What is decode in informatica?
