Answer / sujana

v can do dis by using rank tranf... grpby dept no and rankindex=5

Answer / kiran

CREATE ONE ROUTER IN THIS CREATE 3 OUTPUT PORTS LIKE DEPT10,DEPT20,DEPT30.THEN OUTPUT OF THIS GIVE TO RANK IN RANK SPECIFY TOP AND NO OF RNAKS 5 THE WE GET EACH DEPT WISE TOP 5 RANKS.

Answer / ashwin

A simple way is here:
1: Drag & drop source and target
2: Create a Rank Transformation in between them
3: Open the rank t/r & go to Ports
4: Give Sal as 'R'(Rank) & Tick Group by on Deptno
5: Goto Properties select Top/Bottom,No.of Ranks=(as you need)

Answer / suguna

by using rank transformation rank of salary and aggregator
transformation for group by dept wise

Answer / sujana

@above

in rank also v hav grpby option..no need 2 use aggregator

Answer / jay

Override SQL in source qualifies with bellow query

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 10 order by Sal desc

Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc


Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 30 order by Sal desc

Answer / gd

First override source qualifier
Select * from emp where deptno in(10,20,30);

Next sorter T/r sort on salary column desc

Then rank T/r set rank properties top and number of ranks is 5

target achieved

Answer / jay

Override SQL in source qualifies with bellow query

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 10 order by Sal desc

Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc


Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

Why we use partitioning the session in informatica?

2 Answers  

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.

0 Answers  

How does the session recovery work.

1 Answers  

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

Explain about perform recovery?

1 Answers