in Technology by
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows

1 Answer

0 votes
by

The idea behind this is to add a sequence number to the records and then take the Top 1 rank and Bottom 1 Rank from the records.

  1. Drag and drop ports from source qualifier to two rank transformations.
    source-qualifier-informatica-interview-questions
  2. Create a reusable sequence generator having start value 1 and connect the next value to both rank transformations.
    reusable-sequence-generator-informatica-interview-questions
  3. Set rank properties as follows. The newly added sequence port should be chosen as Rank Port. No need to select any port as Group by Port.Rank – 1
    set-rank-properties-informatica-interview-questions
  4. Rank – 2
    Rank-2-informatica-interview-questions
  5. Make two instances of the target.
    Connect the output port to target.
    target-instances-informatica-interview-questions

Related questions

0 votes
    How do you load only null records into target? Explain through mapping flow....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    How do you load alternate records into different tables through mapping flow?...
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    How do you remove Duplicate records in Informatica? And how many ways are there to do it?...
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    If a current of 0.5A flows through a metallic wire for 2 hours, then how many electrons would flow through the wire ? Select the correct answer from above options...
asked Jan 5, 2022 in Education by JackTerrance
0 votes
    A hash table can store a maximum of 10 records, currently there are records in location 1, 3,4,7, ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    How do you convert single row from source into three rows into target?...
asked Mar 28, 2021 by JackTerrance
0 votes
    In control applications, how many ways are there to control a plant? (a) 1 (b) 2 (c) 4 (d) infinite Please answer the above question....
asked Aug 23, 2022 in Education by JackTerrance
0 votes
    How many primary ways are there for detecting buffer-overflow? (a) 6 (b) 3 (c) 2 (d) 5 I have been ... bank, Cyber Security questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 4, 2021 in Education by JackTerrance
0 votes
    How do you load more than 1 Max Sal in each Department through Informatica or write sql query in oracle?...
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    In how many different ways can it be done ? 10 men and 8 women out of which 5men are teachers, 3 men doctors and ... 150 C. 214 D. 20 Select the correct answer from above options...
asked Nov 13, 2021 in Education by JackTerrance
...