Interested to Buy Any Domain ? << Click Here >> for more details...
select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
- 5 Answers
- 8806 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / chandra mouli
In Mapping take two transfermations.
1.aggrigate transfermation
2.filter transfermation.
in aggrigate add one output port is minsal
minsal=MIN(SAL).next in filter condition SAL > minsal.
next link the ports to target.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain the tuning lookup transformation - informatica
Why update strategy and union transformations are active?
How to load a Dimension ? and how to load a fact table?
expain about the tune parameters?
How can you generate reports in informatica?
How would you join a node to the already existing domain?
Describe data concatenation?
What is status code in informatica?
Do you find any difficulty while working with flat files as source and target?
What is an expression transformation?
What are the different types of olap? Give an example?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is fact table? Explain the different kinds of facts.
