Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is the use of an aggregator cache file?
what is the difference between static and dynamic
why do u use shortcuts in informatica.?
What are the uses of etl tools?
What are the types of schemas we have in data warehouse.
Can a joiner be used in a mapplet.
What is aggregate cache in aggregator transformation?
without matching columns in two tables. how can you join
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
What are the challenges of Dataware housing in the future?