All Questions
Tagged with informatica-powercenter informatica
857 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
-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
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
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
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
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
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
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
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 ...
0
votes
1
answer
146
views
Lookup Condition in Informatica for double and decimal datatype
I have a lookup table which have column name 'Serial_Number' in double format and source table (SQ) Serial_Number in double format. How both table can be connected in the lookup condition?
I am trying ...
0
votes
1
answer
418
views
Create a file list in IICS informatica and load the files to a table
I want to load a bunch of files with the same structure and same name format(ABCD_MMYYDD) every month from local folder to Snowflake table. The server we use is a windows server. So I wanted to know ...
- 27
0
votes
1
answer
135
views
Handling Soft Deletes in Informatica Source Qualifier
I need to compare the target table data with its multiple Input tables for the different source systems of them for doing soft deletes.
Please note that input tables of the target will vary for each ...
- 251
0
votes
1
answer
260
views
How to Transpose a column Data into separate rows in Informatica
I Have a scenario where I have to Convert a Column Data into Separate rows based on a ID values.
For Example
CURRENT DATA :
2100402472 --> Owner;Tenent;Sub-Tenent
EXPECTED DATA :
2100402472 Owner
...
- 251
1
vote
1
answer
37
views
Handling Deletes in Informatica Based on Constraints
I have a Scenario where I have to Do deletes in target table , But this target table has Parent Child relationship with other 3 Hierarchy Tables , Hierarchy 1 , Hierarchy 2 and Hierarchy 3 tables for ...
- 251
0
votes
1
answer
1k
views
CMN_1022 Database driver error... CMN_1022 [ [Informatica][ODBC Oracle Wire Protocol driver]Connection refused
Team, I am getting this error in informatica cloud when i run the mapping.Oracle is running properly, informatica connection is working properly still throw this error..
I have attached the screensort....
- 1
2
votes
1
answer
134
views
How to update variable inside a parameter file
lets say i have a parameter file
[Global]
$$param1=x
$$param2=r
$$param3=t
$$param4=h
$$param5=j
$$Counter=0
what i want is whenever i run the session the parameter file updates and $Counter variable ...
- 303
0
votes
0
answers
151
views
How to convert string that doesn't have date format into date in informatica
i have a date like this $$date='20230614'
what i want is to convert this string to date like this '2023/06/14'
i tried to convert it on expression transformation using TO_Date function
TO_DATE($$date,'...
- 303
0
votes
0
answers
757
views
Informatica Target table is not loading data as expected
I have a source query which picks data on a daily basis and the mapping is fairly simple which directly inserts data into target. We are however not able to see some users getting inserted into the ...
- 1
0
votes
2
answers
138
views
Informatica Incremental extract and load process
We are fetching the source data from oracle db where we have data along with create date and modify date available. For initial load we are fetching full data and loading it.
For incremental load we ...
- 287
0
votes
2
answers
309
views
How to read source file path from text file in informatica
I have a flat file and its path is stored inside text file i want to read that path from text file and use it inside session task to execute the session
and i want to read this file and take that ...
- 303
0
votes
1
answer
162
views
How to compare string with Latin characters to same string with English characters in IICS?
For example, how to successfully compare "André" and "Andre"?
I tried some Reg_replace options without any success.
- 5
0
votes
1
answer
104
views
in informatica - loop through based on different condition
in continuation to the question posted
loop through based on different condition in informatica
i am trying to find a way to loop through the set of entries in informatica , if some condition is not ...
- 11
0
votes
0
answers
89
views
There is unexpected duplicate records in my informatica mapping. I am unable to find from where they are coming?
In my informatica mapping, initially the source was relational one. I changed it to file and now duplicate records are coming in the target.For example there is only 750 records in my source but in my ...
0
votes
0
answers
578
views
LM_36320 Session task instance [s_m_scdone]: Execution failed
Please help me out im getting this error in informatica powercenter in workflow monitor.
After starting workflow i'm getting this error
LM_36320 Session task instance [s_m_scdone]: Execution failed.
...
0
votes
1
answer
143
views
How to join the source data having 100 million records?
In Informatica powercenter the normal join is working for src file having data 10000 records,but it's throwing error for 100 million src records.How shld I fix this issue?
I have enabled the sorted ...
0
votes
1
answer
279
views
Running Postgres insert sql using command prompt informatica
I am running the below postgres insert sql script through informatica command prompt. Able to run the script successfully.
Only issue is in script we are passing password as hardcoded value but its ...
- 287
1
vote
1
answer
1k
views
Informatica Cloud Expression Transformation Convert UTC String to DateTime
I want to convert the UTC datetime in string format to datetime format:
"2016-05-12T21:19:51.2946214Z" -> 2016-05-12 21:19:51.294
I tried to first remove the letters in the original ...
- 71