by
How do you convert single row from source into three rows into target?

1 Answer

0 votes
by

We can use Normalizer transformation for this. If we do not want to use Normalizer, then there is one alternate way for this.

We have a source table containing 3 columns: Col1, Col2 and Col3. There is only 1 row in the table as follows:

Col1 Col2 Col3
a b C

There is target table contains only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:

Col

a
b
c
  1. Create 3 expression transformations exp_1,exp_2 and exp_3 with 1 port each.
  2. Connect col1 from Source Qualifier to port in exp_1.
  3. Connect col2 from Source Qualifier to port in exp_2.
  4. Connect col3 from source qualifier to port in exp_3.
  5. Make 3 instances of the target. Connect port from exp_1 to target_1.
  6. Connect port from exp_2 to target_2 and connect port from exp_3 to target_3.

Rows-informatica-interview-questions

Related questions

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
    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 to join three sources using joiner? Explain though mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    Differentiate between Router and Filter Transformation?...
asked Mar 28, 2021 by JackTerrance
0 votes
    What is the difference between Mapping and Mapplet?...
asked Mar 26, 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'm Running Ubuntu 16.04 LTS with Python 3.6.8 and I have the following code that allows me to ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 8, 2022 in Education by JackTerrance
0 votes
    Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into ... Peter, Paul, Mary? Select the correct answer from above options...
asked Jan 28, 2022 in Education by JackTerrance
0 votes
    How to concatenate multiple rows into a single string in sql a. COALESCE b. STRING_AGG C. Option 1 & 2 d. None of the above...
asked Feb 19, 2023 in Technology 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
    How do you load only null records into target? Explain through mapping flow....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    Which command will you chooese to convert a colume of data in row Select the correct answer from above options...
asked Dec 14, 2021 in Education by JackTerrance
0 votes
    How will you convert a single character to its integer value in python?...
asked Nov 24, 2020 in Technology by JackTerrance
0 votes
    I have csv file and that looks like following. I want to remove all rows before one row values [ ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 14, 2022 in Education by JackTerrance
0 votes
    Problem: Select first N rows and last row in Python Pandas. only gets 1 row which is index 9 and ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 7, 2022 in Education by JackTerrance
...