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
- 9322 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
What is fact table? Explain the different kinds of facts.
What is a sequence generator transformation?
What is the need of an ETL tool?
What is the session task and command task?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain pushdown optimization $pushdownconfig parameter - informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
how we can load rejected record's at run time?(not through bad files)
What is the difference between informatics 7x and 8x and what is latest version?
What is the use of source qualifier?
What is primary and backup node?
Define mapplet?
How to do the error handling of if ur source is flatfiles?
Name the different lookup cache(s)?
Mention a few design and development best practices for informatica?
