Interested to Buy Any Domain ? << Click Here >> for more details...
Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??
- 3 Answers
- 8860 Views
- IBM, I also Faced
- E-Mail Answers
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 |
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
explan ur project architecture?
What is difference between a gateway node and worker node?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
which quality process u can approach in ur project
What is the Difference between DSS & OLTP?
define galaxy repository in informatica
how can u approach u r client
how to we create datamart?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What are the types of caches in lookup? Explain them.
Teradata 
