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 |
in what type of scenario bulk loading and normal loading we use?
When we are using Dynamic Cache,which options we will select in session level?
Can anyone tell me the new features in Informatica 9 Version?
Can you copy the session to a different folder or repository?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
What are the tasks that source qualifier perform?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
Why we use lookup transformations?
I have a flat file, want to reverse the contents of the flat file
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the types of data warehouses?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps