in Technology by
How do you load alternate records into different tables through mapping flow?

1 Answer

0 votes
by

The idea is to add a sequence number to the records and then divide the record number by 2. If it is divisible, then move it to one target and if not then move it to other target.

  1. Drag the source and connect to an expression transformation.
  2. Add the next value of a sequence generator to expression transformation.
    Alternate-records-informatica-interview-questions
  3. In expression transformation make two port, one is “odd” and another “even”.
  4. Write the expression as below
    Expression-transformation-informatica-interview-questions
  5. Connect a router transformation to expression.
  6. Make two group in router.
  7. Give condition as below
    Transformation-condition-informatica-interview-questions
  8. Then send the two group to different targets. This is the entire flow.
    Flow-informatica-interview-questions

Related questions

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
    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 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 first and last records into target table? How many ways are there to do it? Explain through mapping flows...
asked Mar 28, 2021 in Technology 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
    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
    Which component do you need to use in order to read data line by line from an input flow ... entries into iterative global variables? tIterateToFlow tFileList tFlowToIterate tLoop...
asked Mar 24, 2021 in Technology by JackTerrance
0 votes
    How do data tables help the testers? Which are the different types of data tables?...
asked Oct 19, 2020 in Technology by JackTerrance
0 votes
    How to join three sources using joiner? Explain though mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    After reading the chapter, I know these points: I know that data gets highlighted after being selected. I know ... entry and editing. Select the correct answer from above options...
asked Nov 26, 2021 in Education by JackTerrance
0 votes
    This one will take some explaining. What I've done is create a specific custom message queue in SQL ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 16, 2022 in Education by JackTerrance
0 votes
    How do you update the records with or without using Update Strategy?...
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
...