Page 4 of 4 FirstFirst ... 234
Results 31 to 31 of 31
Like Tree1Likes

Thread: Informatica Real time scenarios

  1. #31
    Junior Member
    Join Date
    Nov 2013
    Posts
    2
    Ans 1) For question pls refer real time scenarios posted by Vijay. below is ans for Q1

    FF->SQ->sorter trf->exp trf->transaction ctrl trf -> tgt

    1)Though in source the records are in sorted order, assuming records are not in sorted order hence using sorter trf to sort records in ascending order.
    2) In exp trf we need 2 variable ports and 2 output ports.
    v_new_cat(variable port)= IIF(category=v_prev_cat,0,1)
    v_prev_cat=category
    o_flag=v_new_cat
    o_filename= 'CAT_'||category||'.csv'
    3) connect to transaction control trf,drag all ports from exp trf.
    In condition we have write as below
    IIF(o_flag=1,TC_COMMIT_BEFORE,TC_CONTINUE_TRANSACT ION)

    4) Connect category,product,o_filename ports from trans ctrl trf to tgt.

    Tht's it, create workflow and run it, so that 2 tgt files will be generated (2 in this case for each category).

    Output
    --------
    CAT_1.csv

    #Category Product
    1 samsung mobile
    1 nokia mobile
    1 htc mobile
    1 iphone mobile


    CAT_2.csv

    #Category Product
    2 dell laptop
    2 hp laptop
    2 hcl laptop
    Last edited by Chaitanya_Informatica; 11-30-2013 at 09:52 AM.

Page 4 of 4 FirstFirst ... 234

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
  •