• Home
  • nagadurgaraju Answers

Answered Questions

  • Aug 22 2010
    04:18 PM
    3043
    6

    Event Wait
    • swapnabogolu

    What is the use of event wait?

    sugato.sam

    • Sep 22nd, 2010

    Event wait is a task created in Informatica to look out for events such as waiting for a file in the specified directory of the server. Once this task is completed, another workflow dependent on this task will get started.

  • Feb 18 2008
    08:55 PM
    25162
    33

    Transformation to Load 5 Flat files
    • sarun5

    What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?

    Star Read Best Answer

    Editorial / Best Answer

    sarun5  

    • Member Since Feb-2008 | Mar 13th, 2008

    Guys I have got the answer for which I asked..here you go

    This can be handled by using the file list in informatica. If we have 5 files in different locations on the server and we need to load in to single target table. In session properties we need to change the file type as Indirect.
    (Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files.
    When you select Indirect, the PowerCenter Server finds the file list then reads each listed file when it executes the session.)
    am taking a notepad and giving following paths and file
    names in this notepad and saving this notepad as
    emp_source.txt in the directory /ftp_data/webrep/

    /ftp_data/webrep/SrcFiles/abc.txt
    /ftp_data/webrep/bcd.txt
    /ftp_data/webrep/srcfilesforsessions/xyz.txt
    /ftp_data/webrep/SrcFiles/uvw.txt
    /ftp_data/webrep/pqr.txt

    In session properties i give /ftp_data/webrep/ in the
    directory path and file name as emp_source.txt and file type as Indirect.

    Anurag

    • Nov 27th, 2017

    You should use a indirect file (which contain path and name of all the 5 files) as source. Transformation depends on the business logic.

    Ashok Gulagond

    • Dec 16th, 2016

    When we have the same structured flat files, why don't simply use UNION make them a single file and then load to target instead of such complication? or UNION doesn't work on flat files?

  • Apr 20 2007
    10:29 AM
    4780
    12

    Can we update target table without using update strategy transformation? why?
    • phanimv

    Amit Gaikwad

    • Jul 26th, 2012

    Step 1: Go to session , and in treat source rows as :UPDATE
    step2: in target table option select INSERT and UPDATE ELSE INSERT :)
    Step 3:Refresh and Run the session .