Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 31
Like Tree1Likes

Thread: Informatica Real time scenarios

  1. #21
    Junior Member
    Join Date
    Aug 2012
    Location
    A, A
    Posts
    3
    In source property select "Add Currently Processed Flat File Name" Port.

  2. #22
    Junior Member
    Join Date
    Aug 2012
    Location
    A, A
    Posts
    3
    Any Alternate solution ?

  3. #23
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    515
    Himanshu,

    That is the only option i think

  4. #24
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    515
    Solution to Q5)

    Connect the source qualifier transformation to the expression transformation. In the expression transformation, create and output port and assign the below expression.

    Code:
    o_output_port = SUBSTR(Input_port, INSTR(Input_port,'/',-1,1)+1)
    Connect this output port of expression transformation to the target.

  5. #25
    Junior Member
    Join Date
    Oct 2012
    Posts
    2
    Can you please provide answers for the remaining questions.

  6. #26
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    515
    For question8, check this link for oracle sql query solution:
    Convert or spell numbers to words in oracle database

  7. #27
    Junior Member
    Join Date
    Feb 2013
    Location
    bangalore
    Posts
    2

    Quetion No1

    By using transcation control transformation we load the data

  8. #28
    Senior Member
    Join Date
    Aug 2012
    Posts
    595
    Can anyone answer for Q8 ??

  9. #29
    Junior Member
    Join Date
    Feb 2013
    Location
    bangalore
    Posts
    2
    we can do by transaction control transformation

    SD->SQ-->SRTR-->TC-->TGT(as file)

    configure like below in transformations in TC if previous _value eqal to cur_value TC_Continue else Tc_commit with filename=product_name port.

    is there any other method using other than TC transformation, please let me know.

    Thanks
    Rajarao M
    Last edited by rajarao; 08-18-2013 at 06:13 PM.

  10. #30
    Senior Member
    Join Date
    Aug 2012
    Posts
    595
    Thank you Rajarao for your quick reply !!

Page 3 of 4 FirstFirst 1234 LastLast

Similar Threads

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