Results 1 to 8 of 8

Thread: Datawarehousing Informatica Questions

  1. #1
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Datawarehousing Informatica Questions

    I have had one requirment URGENT:

    SRC (flat file) --> SRC QFR --> EXP --> STR PROC --> TGT

    Inputs for stored procedure transformation are 3,
    1) name string 2) add string and 3) S_date
    Getting date as string from SRC and converted the string to Date format mm/dd/yyyy in expression. But the problem is stored procedure wants the input as single digit for less than 10 numbers.
    For ex: 1/1/2006 (it won't accept 01/01/2006). But our expression transformation gives date as 01/01/2006.

    How to send the input for stored proc as 1/1/2006?

    (Don't advice me change date format in stored procedure. I wish to get it from informatica if possible)

    Thx

    Thx
    SRIRAM N
    Hope Everything Good

  2. #2
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Datawarehousing-Informatica

    We encounter a problem in Informatica when handling number datatypes from Oracle.

    In the Oracle database, I have the values as "46516387.47" and "46513795.02". I have defined them as number(30,10) and decimal(30,10) in oracle and informatica definition. When this data is read in the source qualifier, I am getting like "46516387.4699999988" and "46513795.0200000033" as I see in the debugger. When i go to Evaluate expression and check the values i could see "46516387.469999998807907" and "46513795.020000003278255". Since I am using these values for performing multiplication and division in my mapping, I am not getting the desired results because of the mismatch in the values.

    And this happens even when I enable high precision.

    Thx
    SRIRAM N
    Hope Everything Good

  3. #3
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Datawarehousing-Informatica

    Hi GEEKS,
    Could you please clear me what will be the difference between different connections like ODBC,DNS,DSN and Others?

    Thx

    Thx
    SRIRAM N
    Hope Everything Good

  4. #4
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Datawarehousing-Informatica

    Could any one please tell me how informatica behaves in the following situation?

    (Let me explain you with example: I have following expression in a mapping I would display either FAIL or PASS status to a record.

    RESULT=IIF((A > (100 - B))OR(C > (100 - D))OR(E<= F AND F>0) , 'FAIL',
    IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))

    Where the following variables are decimals

    A (Decimal(9,2)) = 2.0179896789716073791692725900792e-5
    B(Decimal(9,2)) = 99
    C(Decimal(9,2)) = 50
    D(Decimal(9,2))= 99
    E(Decimal(9,2))= 0
    F(Decimal(9,2))=2681.75

    Problem is that system is showing FAIL but expected to be PASS.
    How the systems behaves with exponent values?
    1) would informatica drops the exponent and takes 2 as 'A'
    2) takes exponent (A) as is (0.00%)

    Thx
    SRIRAM N
    Hope Everything Good

  5. #5
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Datawarehousing-Informatica

    What is the use of LOAD CONFIGURATION in designer?

    Thx
    SRIRAM N
    Hope Everything Good

  6. #6
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Datawarehousing-Informatica

    What is a SUPER GLUE Server in designer? How do we configure them?

    Thx
    SRIRAM N
    Hope Everything Good

  7. #7
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Datawarehousing-Informatica

    What is a DATA LINEAGE? How to configure it? (Designer)

    Thx
    SRIRAM N
    Hope Everything Good

  8. #8
    Contributing Member
    Join Date
    Dec 2007
    Answers
    34

    Smile Re: Datawarehousing-Informatica

    Hi Sriram,

    Using TO_FLOAT conversion function, we can get the exact decimal number.

    Thx
    Prakash


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact