All Questions
Tagged with informatica-powercenter oracle11g
19 questions
0
votes
2
answers
420
views
Cannot connect Informatica to the Oracle DB on Docker
I have a problem with connecting (actually at the pre installing step) Informatica to the Oracle DB running on Docker.
Because of my lack of experience and also knowledge I don’t know what may be the ...
1
vote
1
answer
52
views
ETL data over one column but put partition different column. How can I do it faster?
I ve a mapping to etl one big table has about 3 billion records.
That table has partition on RECORDDATE column and I load just yesterday data to stage table and after stage table loads finished I use ...
- 7,366
-1
votes
1
answer
92
views
Converting data having unix timestamps randomly in data of one column of Oracle
Eg: One row in one column contains below data.I need to convert the unix timestamps to actual datetime in oracle.Please provide sql query to convert.
NOTE: {EOT} is special character End of ...
- 17
1
vote
2
answers
1k
views
Unable to load distinct records via lookup in informatica
This is a very strange thing happening i dont know why. I have created a mapping that transforms the data via expression and loads the data into the target(file) based on lookup on the same target.
...
- 3,950
0
votes
1
answer
126
views
Different timestamps for same sql query in Source Oracle Database and Target same Oracle Database while using Informatica
The source is having Createddate as 17-JAN-18 17.22.39.000000000 in my table.
When I execute the following query:
select CAST(Createddate AT TIME ZONE 'UTC' AS Timestamp) from Employee
on Oracle ...
- 17
1
vote
1
answer
844
views
Our database team wants to revoke the PUBLIC privilege to the packages UTL_FILE, UTL_HTTP, UTL_TCP, UTL_SMTP, DBMS_RANDOM
I am a Informatica developer and using source and target are Oracle database.
My database team asking that do you need EXECUTE permissions to the packages UTL_FILE, UTL_HTTP, UTL_TCP, UTL_SMTP, ...
- 47
0
votes
2
answers
40
views
how to rank data based on date grouped by year?
My input data looks like below:
Fisclyear__ date
2011 ______7/1/2010
2011 _____ 8/20/2010
2011 ______2/30/2011
2012 ______6/30/2011
2012 ______8/15/2011
2013 ______7/15/2013
2013 ______7/30/...
- 19
1
vote
3
answers
648
views
Oracle queries getting stuck intermittently
We are having datawarehouse set-up where Informatica is used as ETL tool, Oracle 12c as database and various reporting tools. For reporting, we use queries to get staging data. These queries are run ...
- 231
0
votes
1
answer
973
views
Setting timeout for query in oracle
We have data warehouse setting where we use oracle 12c and informatica for ETL. We call some hourly procedures in informatica workflow. Sometimes these procedures take more than one hour for various ...
- 231
0
votes
5
answers
1k
views
Informatica 9.5.1, huge table (scd1)
I have a table(in oracle) size about 860 million records (850gb) on top we are getting about 2 -3 million records as source (flatfile).
we are doing a lookup on target if record already exist it will ...
- 111
2
votes
0
answers
608
views
How to log errors in Informatica?
Due to security issues the user or Informatica has grants to create neither tables nor synonyms.
So I have come up with this:
The PMERR_DATA, PMERR_MSG, etc. tables are created under another user
...
- 6,478
-2
votes
1
answer
1k
views
Display those employees whose salary is less than his manger but more than the salary of any other manager using ORACLE SQL query [closed]
Display those employees whose salary is less than his manager but more than the salary of any other manager using ORACLE SQL query
0
votes
2
answers
209
views
how to select the minimum non-zero number in aggregator transformation informatica?
I have aggregator transformation already in place. It groups the data on bases of CODE and DISTANCE is arranged in descending order. So the we have to pick the row on the basis of DISTANCE only....
0
votes
3
answers
122
views
Replace function asking for argument in oracle query
I am trying to run below query
SELECT REPLACE('SURES&npsp','&npsp', 'H') FROM DUAL
When i run it's asking two inputs for both the above '&npsp'.
Actually my requirement is to ...
- 1,216
0
votes
0
answers
402
views
Handling Character Set in Informatica
We have a Scenario where Progress DB is my source and we have a ETL job which will load data reading from Progress and loads to Oracle , but some character set needs to be handled like below.
. Some ...
- 2,278
1
vote
1
answer
343
views
Logic behind loading dimension tables
How do I populate Dim_tbls from a relational source?
These example tables are given:
tbl_sales: id_sales, fk_id_customer, fk_id_product, country, timestamp
tbl_customer: id_customer, name, ...
- 825
1
vote
0
answers
127
views
Substring - Fastest way
I would like to substring different values from a string.
The string is usually about 700 characters long and contains ~40 Attributes, which are looking like "City=Paris".
edit: I want only the value ...
- 825
2
votes
2
answers
2k
views
Default values in target tables
I have some mappings, where business entities are being populated after transformation logic. The row volumes are on the higher side, and there are quite a few business attributes which are defaulted ...
- 2,238
0
votes
1
answer
635
views
A simple clarification on informatica mapping logic
I have to work on transformation
Can anyone help me on writing a query for the below transformation
Source Column name (from lookup)
Source table (local_usr_tbl)
Lookup_1:(rpt_user_tbl)
...
- 163