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 frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
What is a joiner transformation?
Explain the different dimensions.
why we r using presql&postsql in source qualifier?
whats the logic to load the lower level of granularity of data to fact table.
What are the various types of transformation?
What are junk dimensions?
How to update or delete the rows in a target, which do not have key fields?
Explain about the concept of mapping parameters and variables ?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?