Questions tagged [informatica-data-integration-hub]
52 questions
2
votes
1 answer
Informatica: How to make a condition for two tables joining execution
Actually, there are total 4 tables invoked in this mapping: Market,Cost, A, B,
Read_sourceTB_B-----FIL1------->---------JNR4 \
| | |
| Read_sourceTB_Market--\ | |
| …
John
- 29
- 4
2
votes
1 answer
Is there a NOT LIKE Function in infornatica?
I know Reg_match(, '.ABC.) is a Like operator in INFA
how can I get a NOT LIKE FUNCTION?
EXAMPLE:
Where Not LIKE %DAVID% and NOT LIKE %ADAM%
1
vote
1 answer
Informatica: dealing with double quotes using expression tranformation
I am developing a mapping in IICS CDI which takes API response as source and save it to a comma delimited .txt file (flat file target).
In the response from the API, since some of the fields contains comma sign "," that field will be surrounded with…
La. Li
- 41
- 6
1
vote
1 answer
IICS Error: "Concatenation disallowed on transformation Joiner. "
I want to join two datasets that are coming from the same source. And I got this concatenation disallowed error.
Below are some details about my problem scope:
For the source: I am extracting from REST API, after parsing the JSON output, there will…
La. Li
- 41
- 6
1
vote
1 answer
How to write reg_extract in informatica expression to fetch multiple email id from text
I am trying to build the logic in informatica to fetch the email id from free text using reg_extract but its not working as expect.I have tried using this logic [a-zA-Z0-9-.]+@[a-zA-Z0-9-.]+[a-zA-Z].Can someone please help with this.
Input:
Data…
Sak
- 61
- 6
1
vote
0 answers
Informatica PowerCenter [PERSISTENCEAPI_0307] [DBPERSISTER_2002] The Repository Service failed to create the repository content
I am getting this error message while creating the MRS (Model Repository Service) in Informatica Powercenter 10.4:
[PERSISTENCEAPI_0307][PERSISTENCECOMMON_0001] Internal error. The request processing failed.
This was caused by…
BiraKishore
- 11
- 2
1
vote
1 answer
How to use decode in IICS when field data contain single quote?
I am new to IICS and my fields that I want to decode looks like below. As you can see the "Outlet_Name" column contains row "NH D'needs". My requirement is to use both columns i.e. Outlet_name and Department and generate an output field call "OD_ID"…
biggboss2019
- 220
- 3
- 8
- 30
1
vote
1 answer
query to retrieve workflow details from repository tables in informatica?
I need to get workflow details like wf name, objects used, run time and throughput from repository tables in informatica. can you help with the query?
kumar
- 37
- 7
1
vote
1 answer
Date format in Informatica expression
In Informatica I use the below expression:
IIF( PARAMETER_NAME='$$CURRENT_DATE_IN_SQL_FORMAT',TO_CHAR(SYSDATE,'YYYY-MM-DD'),'PARAMETER_VALUE')
which give me the date in format 2021-11-25
But I need it me to return value as below…
Partha
- 11
- 1
1
vote
1 answer
How to convert flat file DateTime to Timestamp format in Informatica Cloud Services
Trying to convert the date value coming in from csv flat file (2012-04-03 3:43:00 PM) into Normal timestamp value (YYYY-MM-DD HH24:MM:SS - without AM or PM).
DECODE (TRUE,
is_date(Extract_LAIB_LastCCVRefreshDate__c, 'YYYY-MM-DD HH:MM:SS AM'),…
j_deany
- 67
- 10
0
votes
0 answers
Looping in Informatica Cloud
I have an excel where data is present in key-value format.
Id D-id
2 Null
14 2
110 14
203 110
Here 203 is linked to 110, 110 is linked to 14, 14 to 2. My final goal is to map 203 to 2. Final output will look like
Parent Child
2 …
Arindam Basu
- 1
- 1
0
votes
0 answers
Aggregator transformation
What would happen if we didn't mention any condition and did not opt for the group by aggregator transformation?
if we pass the 20 records at the source side how many records will load into the target
what will be the result
0
votes
1 answer
Informatica like operator
Need help in understanding logic. I have 2 tables from different database. There is one field in common but not the data completely.
As an example:
table 1 the field data is coming as :test
table 2 its coming as - select test from tablename
I need…
Sak
- 61
- 6
0
votes
1 answer
XML Read in Informatica BDM 10.5.3
I am trying to real XML file in Informatica BDM and load this in Teradata table. For this I have created a PDO with complex file data object with below configuration. XML file is placed at my local path.
Resource format: XML
Choose XML file from my…
KeenLearner
- 685
- 1
- 8
- 25
0
votes
0 answers
How to create a rest web service in informatica cloud (IICS)?
I couldn't create a web service in informatica cloud similar to the one we create in informatica BDM. I need to create a web service from which I should be able to pull data from necessary schemas/Tables.
I tried using CAI in informatica cloud to…
