Using Informaica src-->>sq-->>rnk(sal,bottom,1)

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

Question Posted / ankit kansal

5 Answers
9498 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

Please Help Members By Posting Answers For Below Questions

What are ETL Tools?

1043

Is it possible to define a single node as a Gateway node as well as worker node?

1060

Explain lookup transformation is active in informatica

1038

How to do unit testing in informatica? How to load data in informatica ?

1051

Enlist the tasks for which source qualifier transformation is used.

982

What are the different transaction levels available in transaction control transformation?

1122

Explain what is informatica metadata and where is it stored?

989

how to load dimension table and fact table. plz tell me the steps.

2039

What does refresh system mean, and what are its distinctive choice?

1075

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1867

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8130

How to improve the performance of a session using sorter transformation?

1095

What all join we can perform in LOOKUP transformation?

916

differences between service based and product based?

1973

Define mapping and session?

973