1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??

Question Posted / palthepu_santosh

Answers were Sorted based on User's Feedback



Input is like 1 1 1 2 ..

Answer / palthepu_santosh

from source qualifier map the column(id) into two fields of
rank (id,id_grp). select grp_id as group by and rank as 1
output should be
1
2
3

Is This Answer Correct ?    16 Yes 0 No

Input is like 1 1 1 2 ..

Answer / gyana

after source qualifier take a rank t/r
set the group by as column_id and in rank property set
# the number of rank=1
after that connect to target .you can get the desired result

SOURCE---->SQ--->RANK T/R----->TARGET

Is This Answer Correct ?    5 Yes 0 No

Input is like 1 1 1 2 ..

Answer / redflower

src->sq->aggregator->filter->target

from aggt/r we would calculate count(empid)
for eliminating duplicates we will write the filter condition
count(empid)=1

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More Informatica Interview Questions

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

Which kind of index is preferred in DWH?

3 Answers  

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,

How to update source definition?

0 Answers  




who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories