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

  • Checksum and Pipeline

    What do you mean by Checksum and Pipeline in Informatica? Where do you use it ?

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

    Rishak

    • May 21st, 2012

    If you want to check the records,you can directly use MINUS query for eg

    Code
    1.  SELECT  count(*) FROM source
    2. minus
    3. SELECT count(*) FROM target
    4.  
    5.  
    Hope this will help Thanks Risha

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

  • Session variables - what are they exactly

    What are session variables and session parameters. Are the mapping variables and mapping parameters one and the same. I think it is not .

    harikr

    • Dec 7th, 2009

    Parameters and variables are not the same.Parameter is one whose value remains the same throughout a session. You can set an initial value/default value.Variable is one whose value changes through the session. You can perform some functions such as MAX or MIN on the variables.

  • 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?

  • Fact Table - Grain Facts

    What are Grain Facts?

    AVRKAM

    • Jan 3rd, 2010

    This is about granularity. that is, what level of data detail should be made avaialble in the dimension model. A reference to ATOMIC DATA has to be made here.Atomic data is the most expressive da...

  • Mapping variable - Mapping Parameter

    What will happen when Mapping variable and Mapping parameter in Informatica is not defined or given? Where do you use mapping variable and mapping parameter?