1,823 questions
0
votes
0
answers
42
views
informatica repository query to get data lineage of file
I am new in lineage and I have a task which I have to find the data flow details like abc.txt file how it loads till end tables.
ie. abc.txt loads to A table and A is source of B and B is source of C ...
1
vote
1
answer
40
views
How to Handle Target Override When First Set Has No Data in IICS
I have a mapping in IICS with 8 sets of source and target. The first set is configured with the "Target Override" option enabled, while the rest of the sets append data to the target
The ...
- 29
0
votes
1
answer
42
views
Concatenation disallowed in informatica normalizer
I have a scenario which I am trying to implement got stuck
CSV file as command seperated data with 2 columns and both are string
Colum , Data type
sid , string
smark , string
Student.csv
sid,smark
...
- 13
0
votes
1
answer
84
views
Input parameters are not reflected in mapping task
I have parameters created in the mapping, but they are not getting reflected in the mapping task. Only the source and target connection parameters are getting reflected. I cleared the cache as well as ...
- 5,251
0
votes
1
answer
124
views
Processing Parquet files using IICS
I have a parquet file in a gcs bucket containing around 10gb of data. I need to perform some transformations on top of it and load it to Bigquery tables. Is there a way to do it in (IICS)Informatica ...
- 23
0
votes
1
answer
47
views
How to do transaction control transformation without the static target file?
I just developed my ETL using informatica powercenter and I used transaction control transformation to have dynamic output files and it works successfully.
This is the mapping logic
My problem is that ...
- 3
1
vote
3
answers
132
views
How to handle multiple spaces in Informatica?
I have a field in a csv file which has values like:
243 56,
1 673 22,
33 45 789 15
Now, I want to load this file using IICS to a Mysql table but remove all the spaces except the last one. The last ...
- 23
0
votes
0
answers
49
views
Snowflake Function with MD5 Fails in Informatica, UPPER Works - Why?
I’m encountering an issue when invoking a Snowflake SQL function from Informatica. The function works fine in Snowflake but fails in Informatica when using MD5, while it succeeds with UPPER. My goal ...
- 399
0
votes
0
answers
29
views
Modify web service consumer connection in informatica 10.5
I have informatica web service transformation job. I need to modify web service consumer connection to different server as existing one is going to retire. Can you please let me know exact step to ...
0
votes
1
answer
100
views
How to Use a SQL Result As a Parameter In Another Mapping in Informatica Cloud?
I am trying to create an incremental load for a table that has no created/modified date fields, and no CDC on the source database. Since records are only inserted into this table, I would like to ...
0
votes
1
answer
118
views
Informatica partitioning for a insert and update mapping which takes around 2.30 Hours to update seventeen million records
I have a Informatica mapping which does both insert and update on the same table. Currently it tables almost 4 hours to do update for almost seventeen million records. Can any one help me on ...
- 263
1
vote
2
answers
211
views
Why do Snowflake and Informatica (IICS) MD5 function yield a different digest for the same input NUMERIC?
Question:
Is it possible to create an MD5 digest between IICS and Snowflake that both match and can be productionized, as seen in the column outpus for MD5_ZERO and MD5_FIVE in the code snippet below?
...
- 4,069
0
votes
1
answer
116
views
how to create shortcut of source using informatica powercentre
I want to keep my sources and targets in 1 folder and create shortcut of those in other folders and use them, how do I go about doing that?. I am using Informatica PowerCenter 10.4 version.
- 11
0
votes
1
answer
70
views
How to pass the <!DOCTYPE in Informatica Rest service request body
I have a rest API which I am trying to call from Informatica (IICS) service call (Integration Application process).The Target rest API is POST rest API which accept XML in body and the first line of ...
0
votes
1
answer
142
views
How to send an email notification using Python?
I have a Python script that calls an API to fetch information about the job runs we have on IDMC from Informatica. The data queried from the API contains the runID, runName, Status and dates.
I want ...
0
votes
1
answer
115
views
Performance Tuning an Informatica Mapping which has one Insert and 3 Update Logic
I have An Informatica Mapping which has one insert pipeline and 3 Update pipeline , all using an Update Strategy Transformation . The session stats shows that there is an target bottleneck . The ...
- 263
1
vote
1
answer
34
views
Call Informatica wf from different Repository
I need to run already existing wf from different repository with different parameters. Is it possible and how?
- 21
0
votes
3
answers
105
views
Xquery used for counting working days between two dates, but wrong results
In Informatica I got this Xquery line of code build in an Application Integration process:
fn:sum(for $j in 0 to fn:days-from-duration(xs:date($temp.t_laatsteLeverDatum) - fn:current-date())
return ...
- 45
0
votes
0
answers
124
views
Parameter inside SQL Transformation not working properly
Insert query with bind variable is not working in sql transformation when it is parameterized.
insert into abc (a, b, c)
values (?a?,?b?,?c?)
I am calling the above query in a parameter file. ...
0
votes
0
answers
102
views
single quotes in string parameter in sql query override in Informatica developer client
I need to parameterize the query override used in source transformation in Informatica developer client 10.5, so I created a string parameter that will hold the query override.
The parameter query is ...
0
votes
2
answers
80
views
Convert iff expression in informatica to snowflake query
I am trying to convert the below IFF expression from INFORMATICA to Snowflake SQL statement(the column code is a column from a table), but I am unable to:
iif(substr(CODE,0,6)='CE-PUU',
'70NPU'||...
0
votes
1
answer
75
views
How to export data into several Flat Files using Informatica Developer (Big Data Management)?
I have data from Hive table and I want to export the data into several flat files, partitioned by rows, into equal/almost equal number of rows on each target.
Is there any way to partition data into ...
- 27
0
votes
3
answers
126
views
Flat File issue while importing
I have a requirement where I have to offload data from SQL server to a pipe separated flat file. Issue is we have a column whose values are typically all special characters that are present on a ...
0
votes
0
answers
98
views
Informatica WRT_8410 Error, with [Error=]
In informatica I am getting this error
WRT_8410 : Error writing file [error=]
Unable to understand what's causing this error.
0
votes
1
answer
148
views
Using a Command Task to create a shell to run the same workflow again in a loop using nohup
I know that the typical solution to have a recursive workflow call is to create 2 workflows and call each other until a condition is met and the workflow is ended.
But I tried to do this without a ...
0
votes
0
answers
57
views
How to write a MD5 SQL Code in Oracle similar to Informatica Expression Logic for Validation
My requirement is to write a sql code to replicate the MD5 Logic used in informatica expression transformation for Validation Purpose . The MD5 used in Informatica is MD5(TRIM(AGRMNT_NO)||TRIM(SRC_CD))...
- 263
1
vote
1
answer
629
views
Using REG_MATCH and REG_REPLACE function in Informatica to replace a Prefix and suffix of a character
I have a Business requirement in infromatica where we have 2 set of Data's like
'HOUSE ACCOUNT - WELLS FARGO - I' where we
have to remove the suffix ' - I ' and another Data
'JR INSURANCE BROKERAGE ...
- 263
0
votes
1
answer
415
views
How to catch a sub taskflow suspended status in IICS
Does anybody know how can I catch the status of a sub taskflow in a decision to fail it if it is suspended ?
I have a taskflow that have multiple sub taskflows, each sub taskflow have several mapping ...
- 33
2
votes
1
answer
353
views
Using REG_MATCH and REPLACESTR function in Informatica to replace a suffix character
We have a business scenario where the Source Data is getting populated as 'FIRST FINANCIAL SECURITIES OF AMERICA I' where 'I' is getting populated as suffix. We need to remove the character 'I' from ...
- 263
0
votes
1
answer
160
views
Pick the latest file based on datestamp provided in the filename
I have to pick the latest files and copy it to the target folder. For example below are my files in C:\Users\ and the date stamp is after the third underscore i.e. 20240210 in the first file below. so ...
- 34
0
votes
1
answer
135
views
How to load one file at a time in informatica powercenter if file size is large
I have 10 flat files of the same structure which I have to load using informatica powercenter.
I can load them using file repository concept but my files size is large so I want to know is there any ...
- 11
0
votes
1
answer
362
views
Informatica cloud data quality rule validation issue
I have been trying to create a data quality rule in Informatica cloud DQ service. The rule is to check the input is 'Integer' value or not (Validity dimension). The rule logic which I mentioned was : ...
- 3
0
votes
1
answer
41
views
Design a mapping to display the average salary amount of all the employees against each employee record using IICS? How do we do this?
Expected Output:
EMP_ID | EMP_NAME | SALARY | AVG_SALARY
101 | Michael | 1800 | 1800
102 | Ronald | 1800 | 1500
103 | Christoph | 2000 | 1800
104 | Jennifer | 2500 | ...
- 1
2
votes
1
answer
68
views
unable to export deploymentgroup via pmrep. is it supported?
object_type Deploymentgroup does not work for me using pmrep
pmrep objectexport -n dg_map1 -o Deploymentgroup -f test -u c:\temp\zzz.xml
Unknown or unsupported object type Deploymentgroup.
I think i ...
1
vote
0
answers
169
views
How to read XML file by AWS S3 in IICS?
In IICS, I want to read XML file from Amazon S3, and load the record to salesforce.After executing the mappingtask, execute a command statement to back up the XML file in s3.
I create a AWS S3 ...
- 11
0
votes
0
answers
121
views
How to call a procedure in pre-sql that uses function in another database as a parameter in informatica powercenter
Hello i have a question could it be possible to call a procedure in pre-sql that uses a function in another database as a parameter
here's the call in pre-sql
CALL P_Proc_Syntax('X', 'Y',1 ,10
,Fun_x('...
- 311
0
votes
1
answer
94
views
Informatica 10.4 on-prem export-import objects via rest api
Does informatica 10.4 on-prem server supports export-import via rest Api ? need an example.
looked all over and tried al AI's - still unsure that it is supported. most documents are for the cloud base ...
0
votes
0
answers
41
views
I want to generate Alphanumeric series in informatica, and the logic that I am trying isn't working
I want to generate alphanumeric series like below using Informatica PowerCenter and I am stuck coming up with business logic for the same.
A1,A2,A3....B1,B2,B3,....,C1,C2,C3,...C9..
I have used 2 ...
- 11
1
vote
1
answer
276
views
How to process and archive S3 files with timestamp appended in IICS
my source is S3 and fiiicsles are appended with timestamp and the file format is csv. I want to read the data from the file and archive it.
For example : my s3 path s3-abc-asia1/datalake/landing/...
- 49
0
votes
0
answers
316
views
Message Code: CMN_1022 Message: Database driver error...in Informatica Powercenter
enter image description hereWorkflow is failing with this error: Database Driver error ....
while executing Presql query. and it fails once/twice in a week around 8-9am in the morning and continues to ...
- 11
0
votes
1
answer
68
views
Fetching numerical content from string in informatica
I have requirement
I have one input port contains following string value" rad of experience (kms) : 0-50 "
I want to fetch only max value from this i.e.,50 please help me how to fetch max ...
- 27
0
votes
1
answer
112
views
Avoiding dupicate target file in Informatica
I am using flat file target in my workflow and populate the file using FileName property.
It works just fine, but also creates another file with just the headers in it.
I want to disable its creation ...
0
votes
2
answers
450
views
in which situation i have to use transformation instead of sql query in informatica powercenter?
If I can achieve it by writing SQL, is there no need to use the transformation component? and I wanna know in what situation using transformation is better than sql query ? I heard coverting the ...
- 11
0
votes
2
answers
480
views
Scheduling Informatica IICS taskflow
I have a requirement to run a taskflow like below
every 15 minutes - from 1 AM to 3 AM everyday
every 2 hours - from 3 AM to 1 AM everyday
Could you please help me know, if this can be achieved ...
- 31
0
votes
0
answers
90
views
Running 2 stored procedures in post SQL for Informatica
I will like to run two stored procedures in the post session SQL command of Informatica for one of my workflow.
My current code is:
BEGIN
STORED_PROCEDURE_1
STORED PROCEDURE_2
END;
When I ran ...
0
votes
2
answers
612
views
Subtaskflow is getting suspended instead of failed in IICS
I am new to IICS, we have one task flow where there are three sub taskflows inside it and inside sub taskflows we have datatasks so now if the datatask fails the subtaskflow is going into suspended ...
- 1
-1
votes
1
answer
489
views
Instr to find the exact pattern match in informatica
Instr function logic:
**Input** : attr_value and object_name are the field names.
attr_value
object_name
select 'exec test_INC.MC_INS_SO_STAT;' FROM DEFAULTDB
test_INC.MC_INS_SO_STAT
select 'exec ...
- 287
0
votes
2
answers
1k
views
Informatica new line and carriage return
I have file where for one of field data is coming with new line and carriage return(CRLF). Issue is DATA IS not loading as expected due to this as we have row delimeter as \n and due .Example:
Input :
...
- 287
0
votes
1
answer
87
views
Unable to read the JSON array element data from event based kafka topic message connection in IICS/IDMC
We are able to view the kafka topic message as event i/p from Event source connection when it has element with value pair however when an element has an array of data then we are not seeing that data ...
0
votes
3
answers
2k
views
REG_MATCH function in Informatica - Identify a pattern
Can you please help me identify a regex pattern for the below set of strings
1921 abc abc abc 1k
4320 abcs abc Apt 201b
1250 abcd Ave Apt 3c
61a abcd Ave
1b abcd Ave
39r abcd Rd
16w750 abcd Ave
abc ...
- 3