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
- 9164 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 to convert multiple rows to single row (multiple columns) in informatica
What is union transformation in informatica?
How does the aggregator transformation handle null values?
Briefly define a session task?
Which transformation should we use to normalise the COBOL and relational sources?
What is lookup transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the different options available for update strategy?
how to create user defined function (udf) in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Enlist few areas or real-time situations where informatica is required.
Explain the different kinds of facts.
How many ways are there to create ports?
how to load dimension table and fact table. plz tell me the steps.
how to load rows into fact table in data warehouse
