Page 1 of 4 123 ... LastLast
Results 1 to 10 of 32
Like Tree1Likes

Thread: Informatica Real time scenarios

  1. #1
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514

    Informatica Real time scenarios

    I am posting informatica real time scenarios here. You have to implement the mapping logic and post the answers here with corresponding question number.

    Q1) source is a products table. The data in the source table is shown below

    Code:
    Category, Product
    -------------------
    1,   samsung mobile
    1,   nokia mobile
    1,   htc mobile
    1,   iphone mobile
    2,   dell laptop
    2,   hp laptop
    2,   hcl laptop
    I want to create a flat file for each Category and load the related products into that flat file. Create a workflow to implement this logic

    More scenarios at:

    informatica scenarios
    Last edited by vijay; 10-17-2013 at 05:26 AM.

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q2) Source table contains only one row and one column. The data in the source contains a number n. Now in the target i want to load the sequence numbers starting from 1 to the n. As an example, if the source contains the number 5, the data in the target should contain the below rows.

    Code:
    1
    2
    3
    4
    5

  3. #3
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q3) This is an extension to the problem 2. Here the source contains the number of years. You have to generate a time dimension using informatica and load the data into the target. Generate the time dimension starting from year 2000 to the number of specified years in the source.

  4. #4
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q4) Source is a flat file. I want to load the data of the flat file into the target along with the file name. For example, the source is products data which is shown below:

    Code:
    > cat products.dat
    Chocolate
    Biscuit
    The target should contain the below data:

    Code:
    product,     filename
    ------------------------
    Chocolate,  products.dat
    Biscuit,      products.dat

  5. #5
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q5) Source contains the list of file names with a complete directory structure. Sample data is shown below.

    Code:
    /var/tmp/docs.txt
    /usr/local/bin/add.sh
    /usr/bin/sum.pl
    Remove the directory path from the source and load only the file names in the target. The data in the target looks as shown below:

    Code:
    docs.txt
    add.sh
    sum.pl
    Doug11 likes this.

  6. #6
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q6) The source data is shown below:

    Code:
    Ename, Deptcount
    ------------------
    Mark,   3
    Henry   2
    Chris    1
    In the target table, i want the output according the dept count. I want to repeat Mark 3 times, Henry 2 times and Chris 1 time in the target. The data in the target should look as

    Code:
    Mark,   3
    Mark,   3
    Mark,   3
    Henry   2
    Henry   2
    Chris    1
    Create a mapping to solve this informatica problem.

  7. #7
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q7) Load the top 10 employees in each department based on the salary without using the rank transformation. Implement mapping logic for this.

  8. #8
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q8) The source is a relational table and the data is shown below:

    Code:
    value
    --------
    65020
    78250
    58264
    Convert the numbers into string format and load into target using informatica. The target data is:

    Code:
    sixtyfive thousand ninty
    seventyeight thousand fifty
    fiftyeight thousand twosixtyfour

  9. #9
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q9) Source is a employees table. The structure and data in the employees table is shown below

    Code:
    empNo, empName, empPhone, empAddr, empEmail
    ------------------------------------------------------
    1,        Gayle,       601-204,   UK,         Gayle@post.com
    create a normalized target table structure and load the data into it. The structure and data of the target table is shown below:

    Code:
    empNo, empAttribute
    ---------------------
    1,        Gayle
    1,        601-204
    1,        UK
    1,        Gayle@post.com
    Create a mapping logic to solve this problem.

  10. #10
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Q10) Source contains a varchar column. The data in the source looks as

    Code:
    abcd
    1234
    height
    6890
    1a2b
    Implement a mapping to identify only pure numbers in the source and load those numbers in the target. The target should contain 1234, 6890.

Page 1 of 4 123 ... LastLast

Similar Threads

  1. MongoDB Vs Oracle for Real time search
    By Oracleguy in forum Oracle
    Replies: 0
    Last Post: 12-11-2012, 09:23 PM
  2. Soak Testing in real time
    By Manoj Tiwari in forum Testing
    Replies: 1
    Last Post: 10-04-2012, 06:16 AM
  3. Real time processing in informatica
    By akhil in forum Data Warehouse
    Replies: 0
    Last Post: 08-01-2012, 11:20 AM
  4. Replies: 1
    Last Post: 07-03-2012, 12:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •