1,285 questions
0
votes
1
answer
31
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 ...
- 251
0
votes
0
answers
14
views
Informatica Powercenter - Handle error in HTTP Transformation
In Informatica Powercenter, I want to handle error when calling an API with an HTTP Transformation.
For example, I have 10 lines in input. I will call the API 10 times to get the datas.
But when the ...
- 89
-1
votes
0
answers
16
views
Copying files from source folder to target folder. This needs to be done in IICS without the use of mass ingestion
I have 3 files in folder_A at location "c:/source/folder_A". The file names are
file1.txt
file2.txt
file3.txt.
And these 3 files has to be copied to the location "d:/source/folder_A&...
0
votes
0
answers
66
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
2
answers
49
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
32
views
Can't see SQL Server option in Informatica Cloud when creating "Target Connection"
I'm new to Informatica so please bear with me.
I'm trying to create a simple job in Informatica Cloud that copies data from one SQL Server DB to another.
In "Connect Source" I created the ...
- 3,285
0
votes
0
answers
32
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
0
answers
13
views
Extracting a pattern in Informatica
My input looks like
FIELD1 = 10000000,00, ,,00,Q,,00, ,,00,X,,00,2,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,00,Q,,...
0
votes
1
answer
71
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 ...
1
vote
1
answer
198
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 ...
- 251
2
votes
1
answer
151
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 ...
- 251
0
votes
0
answers
22
views
Hive ParseException-Unable to load Hive target table on Informatica PowerCenter
I am getting the following error when trying to load a Hive table using PowerCenter (ODBC connection):
: Rowdata: (Row Type=0(insert) Src Rowid=4 Targ Rowid=4
)
LIBRARY_NAME (LIBRARY_NAME:UniChar. 100:...
0
votes
1
answer
75
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
60
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
0
answers
21
views
Efficiently parse data in a flat file
I have a flat file containing data structured in a specific pattern, where each row consists of alternating fields. For example:
A|B
E|F|G|H
J|K|L|M
In this data, 'A' represents field 1, 'B' ...
- 35
0
votes
0
answers
40
views
Informatica-How to limit number of rows from Mainframe source
For relational databases we can limit the number of rows using SQL Transformation in Source Qualifier. Is there any similar way we can do for Mainframe Source?
- 123
0
votes
0
answers
40
views
How to use a function that return refcursor in mapping in informatica powercenter
hello i have a function that return sys_refcursor
and i use this function inside a stored procedure as a parmater i tried to import the function as stored procedure transformation in the map but the ...
- 303
0
votes
0
answers
77
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('...
- 303
0
votes
0
answers
14
views
Partitioing using indirect file method
After creating mapping can we use partitioning on indirect file method
can we perform it or not.
i faced this question in one of the interview. can some one help on this.
how to implement partitioing ...
0
votes
2
answers
35
views
Need to generate new sequence for duplicates values
input
Name region
abc india
def austrila
ghi india
jkl austrila
Output is
Name region glr_code
abc india 001india
def austrila 001austrila
ghi india 002india
jkl austrila 002austrila
need to get ...
0
votes
0
answers
30
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 ...
0
votes
0
answers
41
views
Insert into empty MongoDB collection using informatica power center
I have established a MongoDB ODBC connection and trying to load from Oracle db to MongoDB collection using informatica power center.
When collection is empty workflow fails and doesn't load anything. ...
0
votes
2
answers
233
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
1
answer
126
views
How to convert ansii file to utf-8 encoded file through informatica workflow?
How to create UTF-8 encoded file through Infa PC workflow?
I have tried changing the settings to UTF-8 in file properties at workflow level and mapping level and also tried generating the file in ...
- 11
2
votes
2
answers
256
views
How to match the values generated by MD5 hash (Informatica) and Standard hash (Oracle)?
Is there a way to match MD5 hash generated by Informatica and Standard hash (Oracle)? The values generated by Informatica and Oracle are different.
Example:
MD5 hash (Informatica)
MD5(TO_CHAR(...
- 37
0
votes
2
answers
375
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
330
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
0
answers
71
views
Ho to change existing MD5 checksum value to make it different from previous value
I have loaded some data from source to target through powercenter mapping , in this mapping update happens when src md5<>tgt md5 c so what happend is through unconnected like we are returning 1 ...
0
votes
2
answers
740
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
56
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
2
answers
262
views
Affected rows from seesion logs does not reflect in actual target table in Informatica
I have a simple mapping loading source to target (Postgres table), on running the session when I check 'Get Run Properties' I can see a certain number of rows affected, but in reality, there is no ...
- 53
0
votes
0
answers
52
views
Sequence-id in associated expression for dynamic lookup in Informatica Powercenter
I have a mapping using a dynamic lookup on target table followed by a target table.
The target table has a primary id column that is passed from the lookup column where I have used 'Assoicated ...
- 53
1
vote
2
answers
170
views
how to lookup on a table based on a null key in informatica powercenter
hello guys i have 2 tables
table 1
---------------
col1 col2 col3
NULL 1 update
123 1 y
159 2 f
table 2
----------------------
col1 col2 col3
NULL 1 x
123 1 z
i want my table ...
- 303
0
votes
0
answers
312
views
PMCMD Command to get session statistics Informatica
I have a requirement to use pmcmd command to get session statistics. I have updated the .bash_profile and logged in to the pmcmd path. However, I'm not able to connect to the integration service ...
- 11
0
votes
0
answers
71
views
can we use informatica power center to load into teradata cloud?
Currently we are using Teradata as our primary database. We are doing a POC in teradata cloud.
In our current interface setup we are using Informatica power center to load data into teradata , So can ...
0
votes
0
answers
49
views
Informatica Incremental Load using greenplum writer
I have a general question regarding the informatica incremental load process. Currently I am using the flow as source(extract)-->stage(load - find out inserts and updates)-->load into main table(...
- 287
0
votes
0
answers
225
views
How to call APIs in Informatica Powercenter
My inquiry is there's a possible way to call APIs in Informatica Powercenter?
I tried to use two transformations like HTTP, Web Service Consumer (WSC) Transformations.
It's really complex and not ...
- 303
0
votes
1
answer
56
views
how to create ETL to dynamically get the port name
i have a table
table:
col1,col2
1,2
3,4
i want to create ETL to extract only port/column name in another table example my target table should contain one column with 2 rows contain column names
...
- 303
1
vote
0
answers
59
views
how to read json messages from kafka and write to flat file in informatica powercentre?
I have a mapping where I am trying to read serialized messages in Json format from Kafka topic in informatica PowerCenter and process to flat file. However, when I run the workflow, it reads messages ...
- 33
1
vote
1
answer
76
views
ETL mapping to load employee whose first name has space in it in informatica Power Center
Consider employees table as source. Create an ETL mapping to load employee whose first name has space in it.
E.g First name like (Jose Manuel, John Paul)
- 121
0
votes
0
answers
202
views
Informatica Powercentre not able to read messages from Kafka source topic. how to read Json message from Kafka topic in informatica powercentre?
I have a simple workflow where in the source is kafka topic and target is flat file. it is a one-one mapping. I have imported the kafka topic and created mapping as follows.
I have imported the Kafka ...
- 27
0
votes
1
answer
701
views
Informatica Powercenter String to Decimal Conversion
I am trying to load data from flat file to oracle table.
The flat file has data as string and the value is 123412345678.123457689123
When converting to decimal , the value is becoming as 123412345678....
- 444
0
votes
1
answer
120
views
Informatica PowerCenter - How to get all occurrences of a string and its subsequent values from CLOB field in source table
I have a CLOB field in the source Oracle table and would like to extract all occurrences of the string that matches the pattern 'RES_GetResData_Public_ScreenPrint' and its subsequent values (which are ...
- 37
0
votes
1
answer
255
views
How to check the used space during run of an Informatica Powercenter Workflow?
I'm trying to find out more about the space that Informatica Powercenter takes up when a Workflow is executed.
At the moment, we have a table on an Oracle server that weighs about 300 MB and has ...
- 77
1
vote
1
answer
56
views
Compare Rows to only send specific rows in Informatica
I needed guidance on how to solve for below in informatica powercenter.
My source flat file.
|Student|Subject|PF|
|1|Science|Fail|
|1|Maths|Pass|
|2|Science|Fail|
I need to apply logic where if a ...
0
votes
1
answer
263
views
ORA-00932: inconsistent datatypes: expected NUMBER got CLOB in INFORMATICA PowerCenter
I get the below error while trying to run a session in informatica.
ERROR 10/11/2023 2:56:21 PM node02 READER_1_1_1 RR_4035 SQL Error [
ORA-00932: inconsistent datatypes: expected NUMBER got CLOB
...
- 37
0
votes
0
answers
104
views
Normalizer transformation in Informatica to Convert Columns to rows Based on a ID Column
POLICY_NUMBER
AGENT_NUMBER_1
AGNT_PCT_RT_1
AGENT_NUMBER_2
AGNT_PCT_RT_2
SC123456789
CL00022250
50
CL00050083
25
The Data should be Normalized in Informatica like shown below Using Normalization ...
- 251
0
votes
0
answers
72
views
In informatica Target has two primary keys one has duplicate rows but with other pk combined it will be unique
In target there is data like
Rowid batchnum sold
1 10 Null
1 20 Null
Now the requirement is sold column is new column and we need to insert the data to sold column by taking ...
- 1
0
votes
1
answer
689
views
Informatica new column data loading into existing target table
I have an requirement as there is one existing target table and now requirement is we have included one new column to it and the data to the target table should load from a new source table in new ...
- 1
0
votes
1
answer
238
views
Filtering rows that ends with a certain value in Informatica mapping
I will like to filter out rows which col1 ends with a certain value in my informatica mapping.
In SQL I will write it this way
Select * from table where col1 like ‘%- Test’.
Is it possible to ...
