Submitted Questions

  • UNIX find, grep, sed

    What is FIND, GREP and SED? Could you please give me the difference between all the three? Where we use this commnands?

    Mustafa

    • Jun 14th, 2014

    Find command is used to find a file.
    grep command is used to find a contain or string in a file
    sed command is used for filter purpose, if want to replace a word, want to print particular line of the file etc

  • Dimensional modelling vs Data modelling vs ER modelling

    What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.

    Manjunath

    • Apr 9th, 2015

    both Dim Modeling and ER modeling can be 3NF, which is highly normalized, As raj mentioned ER is used for OLTP and DM for OLAP. in both the cases data is stored in a set of tables and related to each ...

    Sharat

    • Jan 5th, 2015

    Raj, 1NF is highly denormalized and the higher forms are more normalized. You said Dimensional Modeling is for datawarehouses and uses 3NF. Contains denormalized data. 3NF is highly normalized and how can the datawarehouses can have denormalized data

  • Target Details Verification

    If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.

  • Failed Workflow

    When you run the sessions in a sequence what will happen when the first workflow fails and later you want to start with the second one and followed by others. Where will you do changes or necessary steps to run the workflow.

  • Joiner Transformation Master Detail

    Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?

    Star Read Best Answer

    Editorial / Best Answer

    ghola  

    • Member Since Jul-2008 | Aug 15th, 2008


    The joiner transformation compares each row of the master source against the detail source. Hence, fewer number of rows in master means fewer iterations of join comparison.

    Secondly It is easier to cache the table with fewer number of rows.

    Hence, using the table having the fewer number of rows as a master improves the performance.

    Raju R

    • Oct 27th, 2015

    @ponnana: The performance of the joiner depends on the rows and not on the columns. Also you take up the condition which consists n number of columns. Based on the condition the rows are obtained. So We need not worry about the columns.

    Rashmi

    • Oct 18th, 2015

    The join is happening based on some condition. Therefore match process depends on the condition columns only and not how many columns are present in total. The table you drag into joiner first is considered as Master.

  • Transformation to Load 5 Flat files

    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 12th, 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?