in aggregator transformation we want to get middle record
how to implement, source containg empno,name sal,deptno,address
Please follow the below, that would be helpful.
https://www.bullraider.com/database/informatica/scenario/101-informatica-scenario35
Is This Answer Correct ? | 0 Yes | 0 No |
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
What is aggregate cache in aggregator transforamtion?
On which transformations you created partitions in your project?
Explain informatica architecture - version 8 / 9
Three date formats are there . How to change these three into One format without using expression transformation ?
What are the ETL tools available in DWH?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Describe two levels in which update strategy transformation sets?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
What is an expression transformation?