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
    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)
    o_filename= 'CAT_'||category||'.csv'
    3) connect to transaction control trf,drag all ports from exp trf.
    In condition we have write as below

    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).


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


    #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


Posting Permissions

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