to follow, share, and participate in this community.
Not a member? Sign Up!
Can anyone suggest sql query to find the mappings, session and command tasks associated with workflow for all project folders in PC 10.0? Hi, I am trying to create a source definition by importing the client provided XML data file. But while importing the source definition, I get the following error: I am not the XML expert and not sure ... Hi, I am trying to use the following XML to create a source and further read the same file to load my table. Backyard Tee - Tequila Sunrise - Navy But I am stuck with the following error while readin... Hello All, I have a mapping where the source is Oracle db. 1. Does informatica processes all the records from source sequentially or in parallel ? 2. I have a mapping where the source records pass through a mappin... Hi, I have incoming records with many different columns and I want one of the columns to have the same value repeated based on the first row. Example given below: In the Input source records, t... Hi I've already asked a very similar question but now I'm testing Pushdow optimization. This is my source (TABLE) product Line Order Toto q... Hi All I have a table with following format with Col B as key. For group of values in Col B, if the col A has code as 'ABC', then that record has to be treated as Master record and rest of the records of that ... Hello, I am splitting a location field into 2 fields (location and location code). The format of the field is something like USA (USA1); so USA -> location, USA1 -> location_code. For loc... Hello, I am stuck at a point where I am not able to move forward. I am trying to find records that exists in Table B but not in Table A which is easy but the caveat is that I need a column in Table A that I need to us... Hello All, We are trying to implement a solution to get data from Rest API call. Would you please suggest or recommend a process using informatica Power Center how can we pass the bearer Authentication token... Hello, I am trying to achieve to write the [GLOBAL_SAHRED] as first line and date to the second line in a flat file in a single mapping. I am using dummy oracle as source and trying to create the output port and... Hello Gurus, I am trying to read a file which has three columns. I created a mapping to read and in the second column I can have two values 'P' or 'F'. If I find the value P then exit code is 0 and workflow should be ... Hello All, I create one xsd file in which we have so many one-many relationship. I create xml generator and it successfully created as per the requirements. COnnected some input ports whcih are required... 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. ... Hi, I have the following XML source file (I just put a portion of my XML source file here and not the entire content due to size). I have created my denormalized XML source using the raw XML file and ... Hello Gurus, I have a dimension table with surrogate key as the primary key. Employee_identifier is the key which is used to lookup and maintain SCD Type 2 history in the table. Employee_identifer is a 7-digit... is DAC 126.96.36.199.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 188.8.131.52.4 supported by Informatica 10.4 DAC ... 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... Gurus, for a given whole number or decimal I need to pad '00' to right and remaining zeros to left if the length is less than 12. For example if the number is 123 then 000000012300. Similarly for decimals if i h... 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