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
- 9032 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 handle two sessions in Informatica
Define Pmrep command?
How do you promote a non-reusable transformation to reusable transformation?
How to handle decimal places while importing a flatfile into informatica?
Did u used latest transformations of 8.6.0? for what?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Why filter transformation is an active one?
Define mapplet?
How many ways a relational source definition can be updated and what are they?
Write the program through which the records can be updated?
What is DR strategy for Informatica project?
Differentiate between source qualifier and filter transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How can one identify whether mapping is correct or not without connecting session?
What are the databases that informatica can connect to windows?
