• REG_MATCH expression

    Hello All,   My requirement for Target_Field_A is as follows: If Source_Field_A like ‘%ORGIN%’ then set ORIGIN,   Else if Source_Field_A like ‘%DEST%, then set DESTINATION.  ...
    Divya Karun
    last modified by Divya Karun
  • is DAC 11.1.1.6.4 compatible with Informatica 10.4 ?

    is DAC 11.1.1.6.4 compatible with Informatica 10.4 ?   i am not able to find in PAM sheet, please help how to validate with Informatica vendor and ensure DAC 11.1.1.6.4 supported by Informatica 10.4   DAC ...
    thamarai kannan
    last modified by thamarai kannan
  • Teradata Timestamp with Timezone Issue in Informatica mapping

    Hello All,   I am creating a mapping where Teradata table is a source and target is a flat file(.csv). I am reading the entire data from the source table (17256447 records). Since the source count is huge, so I...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • PowerCenter 10.5 release date

    Hello   Can someone share the release date of PC 10.5.x and also the PAM.?  I am curious to see if we this supports RHEL 8.x which is very much needed.   Thank you Gurudutt
    user151735
    last modified by user151735
  • Same source and target table to read and update? Can we?

    Hello friends, I have a requirement in such a way that I have to use the target table as source to get the key value and update the same table. The reason being is i need to pull the file date from stage table. Appare...
    Arya Nymeria
    last modified by Arya Nymeria
  • Shell Script to move files from Infa_shared directory to another server

    Hello All,   ######## I want to achieve this via Shell Scripting ########   I have a requirement to move a file(which will come on a daily basis) in unix box location (data/infa_shared/SrcFiles/ABC/). The ...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • How to handle comma and double quotes in data for a .csv output file

    Hello All,   For my requirement, Source is a Hive database and Target is flat file(in .csv format). Now I want to handle both comma , and double qoutes “ and newline as well   Below is the sample dat...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Metrics

    I'm trying to fill out a form for Informatica Cloud Data estimate.In that they are asking about No of jobs, mbs and % .   Can anyone suggest how can we determine mbs and % in PowerCenter 10.0?
    srini komm
    last modified by srini komm
  • Wf Scheduled to run 10 times Monday to Friday

    Hi Team,   I need to run the Wf 10 times every day from Monday to Friday, i have set the bellow properties and wf was running on the day it was scheduled but not scheduling for the next dates. using informatica...
    SP K
    last modified by SP K
  • Indirect Load

    Hello,   I have requirement to load 6 flat files into the target table which are of same structure. I know, we can achieve this by using indirect load option.   But I wanted to know what are the best prac...
    Dhiman Dey
    last modified by Dhiman Dey
  • Parsing xml file in Informatica

    Hi, I am trying to parse an xml file using power center mapping designer and it gives me the following error:   I tried uncommenting the below line in C:\Informatica\10.2.0\server\bin folder and added this as a...
    Mani Ar
    last modified by Mani Ar
  • Webservice Provider - Powercenter Fault handling -Target Issue.

    Hi,   I have a webservice mapping which is currently working fine.Now I want to capture the response and any fault code incase of any errors.When I try to add the webservice target to the mapping and link ports ...
    varsha naik
    last modified by varsha naik
  • Compatibility Console Admin Powercenter 10.1 and Edge Chronium browser

    Hello, I searched for the information but couldn't find it. The PowerCenter 10.1 administration console is compatible or not with the Edge Chronium browser? In addition, would you have the list of browsers compati...
    Jordan Abadie
    last modified by Jordan Abadie
  • Help required in IF ELSE condition

    Hello All,   In an expression transformation, I have 2 ports Ownarea and TargetArea   I want to achieve below scenario   Scenario 1: If Ownarea = 2560 or 0497 or 0498 then { If TargetArea contains...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Extract the date from Input file and generate output target file as per the extracted date

    Hello All,   Please help. I am extracting the files from 3 different AWS S3 folders/sources inside a same bucket to the local infa_shared unix directory by using below shell script ############################...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Override the value of Persistent Variable

    Hello All,   I have a requirement where I have to generate a .xlsx file appended with Previous day date. (I have generated the .csv file in output and then converted it into .xlsx file via ssconvert utility) H...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Read AWS S3 files in Informatica PC

    Hello All,   I have a source system which places the .csv files into an AWS S3 bucket inside a folder on a daily basis and this file later on gets archived at some other location after processing. The naming con...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Read the latest .csv file from AWS S3 bucket

    Hello All,   There is a bucket/folder in AWS S3 where .csv files comes on a daily basis. The naming convention of a .csv file is 2001DBBYLAST-YYYYMMDDHHMISSSSS.csv   This .csv file contains a dot.(Eg: Seri...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • LIKE Clause in Expression transformation

    Hello All,   I have a requirement where in I have to check for below condition(Provided by business) upper(UniBody/Frame Damage)=’YES’ OR upper(Operable)=’NO’ OR TRIM(TRIM(REGEXP_REPLA...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Flat files with different multiple headers and footers

    I have flat file in the below format with multiple headers and footers and I need to Mask/De-identify random columns.   H Col1 Col2 Col3 Col5 D XX1 XX2 XX1 F 000001 H Col2 Col1 Col3 Col4 D XX1 XX2 XX2 D XX1...
    Subrahmanyam Yenumala
    last modified by Subrahmanyam Yenumala