Stack Overflow
Stack Overflow

Questions tagged [informatica-cloud]

Informatica Intelligent Cloud Services is a cloud Integration Platform as a Service (IPaaS) covering ETL, Application Integration, file ingestion, messaging and more via a number of modules like DI, AI, MI, CIH and some additional features on top. It enables customers to design integration interfaces of various nature between cloud and on-premise applications.

216 questions
11
votes
1 answer

How to Create a Process in Informatica Cloud Real time which gets exposed as Restful service and can be invoked from browser or else where?

Can we create a Webservice using Informatica? I am very new to Informatica. Is the below requirement possible in using Informatica? My requirement is - "I want to create a Real Time RESTful webservice within Informatica Cloud which will fetch data…
Oliver
  • 6,152
  • 2
  • 42
  • 75
4
votes
1 answer

Pass a specific time with today's date as a value to the input field in Informatica Cloud

There is a mapping task which has a input field, the value provided to the field should be today's date and time is 18:00:00.000000000. What is the formula to build this one? Suppose the current month is 9, it should be passed as 09. Same with the…
Teja Goud Kandula
  • 1,462
  • 13
  • 26
3
votes
2 answers

Informatica Cloud DB2 for i cdc connection type SQL Override not working

Source for the Informatica Cloud is of type DB2 for I cdc. There are few tables that contain # in their column names. If the mapping was run with a column name containing # in the name then the mapping fails. Example : If there is an Employee table…
Teja Goud Kandula
  • 1,462
  • 13
  • 26
3
votes
1 answer

Cannot reference a standard SQL view in a legacy SQL query - GBQ & IICS

I am relatively new to GBQ. I am trying to create a mappping in IICS to copy one view from GBQ to create a table within GBQ. At this point I am not doing any transformations, just a source to target copy. I am getting the below error - [ERROR] The…
Debojit Pal
  • 33
  • 1
  • 3
2
votes
1 answer

oracle equivalent 'IN' function in informatica

I can't believe it's so hard to find an example in informatica documentation. I would like to check if a string column that matches any of the following strings: 'A', 'B', 'C' In Oracle, it would be as simple as: where column in ('A', 'B', 'C') I…
Dozel
  • 149
  • 1
  • 10
2
votes
1 answer

How to improve performance of a flat file in informatica

Suppose my source system is a flat file and it is having more than 50M records.it is taking 2hrs time to run. How to reduce run time. What performance tuning techniques you can implement at source level
nithin
  • 39
  • 8
2
votes
1 answer

Informatica parallel jobs creating mload issue on Teradata

In the ETL there are 2 parallel jobs and those 2 jobs run start and finish almost at the same time. After they are finished they will update few details to a same look up table. Both the parallel jobs are taking the same amount of time to finish. If…
Teja Goud Kandula
  • 1,462
  • 13
  • 26
2
votes
2 answers

Is there any pre-requisite to call a Snowflake stored procedure from a Informatica mapping?

I would like to know if there's any special requirement when calling a Snowflake stored procedure in a Informatica mapping. Concretely, I have a mapping in which the target is a snowflake table, and as Post-SQL, I want to call a stored procedure…
Marta Piñol
  • 31
  • 2
2
votes
2 answers

The source files structure will be changed on daily basis in informatica cloud

Requirement is, The source files structure will be changed on daily basis / dynamically. how we can achieve in Informatica could: For example, Let's consider the source is a flat file with different formats like with header, without header,…
Jyo
  • 47
  • 5
2
votes
1 answer

Constructing JSON with a number as an attribute name

The following problem is happening inside of Informatica CAI. Here I only have access to Xquery to edit variables and construct data. I am attempting to map a JSON's attribute names into numbers. A readable example of this problem is a…
Joseph Knutson
  • 21
  • 1
2
votes
1 answer

xquery to check if the value is null then return null as string

I am new to XQuery. Please guide me to solve the issue below I want to return the null value as a string, if the below expression does not give any value. Currently, the output doesn't show the 'name' field itself. I want to have a name with null.…
gunjan gupta
  • 51
  • 1
  • 12
2
votes
2 answers

How to call a stored procedure / macros on teradata from informatica cloud?

I am trying to call a macro on Teradata from Informatica cloud but I was not able to achieve any success I tried SQL transformation, it works only for SQL server and oracle but not for teradata. Anyone has any idea how to call a macro on Teradata…
skcgc
  • 69
  • 2
  • 14
1
vote
1 answer

Cannot convert type string to date

I have a flat file with date coming in as 2023062 which I am using the conversion substr(LTRIM(RTRIM(LINE)),76,8) to get it as a variable named INVC_DT, and i created output column as o_INVC_DT with the expression TO_DATE(INVC_DT,'YYYYMMDD'). When I…
Bond
  • 25
  • 2
  • 13
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
2 3
…
14 15