Interested to Buy Any Domain ? << Click Here >> for more details...
follwing scenario two table using find maximum salary?
table a table b
101 xxx 1000 106 6500
103 yyy 5000 108 800
104 din 6000 109 7000
105 dsh 200 110 3000
- 5 Answers
- 9691 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Using Informaica
src-->>sq-->>rnk(sal,bottom,1)
-->>union-->>tgt
src-->>sq-->>rnk(sal,bottom,1)
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about cumulative Sum or moving sum?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to start a workflow using pmcmd command?
can you please explain me pre session and post session options?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How are the sources and targets definitions imported in informatica designer?
What is incremental aggregation?
What is data movement mode in Informatica and difference between them?
How to load last n records of file into target table - informatica
What is a router transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Why update strategy and union transformations are active? Explain with examples.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is aggregator transformation in informatica?
What are the reusable transformations?
