Manage categories

Close

Create and manage categories in Marketplace. Removing a category will not remove content.

Categories in Marketplace
Add a new category (0 remaining)

Manage Announcements

Close

Create and manage announcements in Marketplace. Try to limit the announcements to keep them useful.

Announcements in Marketplace
Subject Author Date Actions
Skip navigation
Contact Us

Ideas

Filter by Categories & Tags

Sort By: Filter by Stage: When:
score 0
Active 0 votes
Created on Aug 20, 2015 1:15 AM by subathra1212@gmail.com - Last Modified: Aug 20, 2015 1:15 AM

Hi,   Does informatica convert string with character to decimal as well as to integer?   Is value '5%0.08%' convert to decimal?   We may think it wont convert. But its wrong. Here informatica 9.5.1 converts to the value decimal and the output is 5.000000000000000   As same as string to integer value conversion,   to_integer('5a.08%') is converted into 5 and to_integer('a5a.08%') is converted into 0.   Without fail the mapping, its simply converts and load.

score 5
Active 1 vote
Created on Jun 23, 2015 3:07 PM by Priyank Reddy Chinthapally - Last Modified: Jun 23, 2015 3:07 PM

Hi,   Is there a way to identify the dependent objects (mappings, sources, targets, lookups, etc) in Informatica Cloud to perform impact analysis? Please note that Powercenter has this functionality but Cloud is still immatured in this feature. Any REST API calls that can be made to retrieve the metadata or third-party application that an be utilized?   Example Scenario: Table A is being used in 20 MTT, 5 DSS tasks as a source or a lookup or a target. I would like to pass the table name, org i …


Read More...

score 5
Active 1 vote
Created on Jun 17, 2015 6:23 AM by swarup patra - Last Modified: Jun 17, 2015 6:23 AM

Hi Folks,       Do we have any options to enable for rejecting the records from the source, if it is not adhered to the data type we have provided or the length is more or less than the defined one. Please let me know if any idea to implement the same.     Moreover, i want to add on the property 'Stop on errors' which does not fail in various instances, however we expect it should.   1. in case of data truncation. 2. The data conversion where we do not use any explicit function to implement …


Read More...

score 0
Active 0 votes
Created on Jun 17, 2015 6:12 AM by swarup patra - Last Modified: Jun 17, 2015 6:12 AM

Hi Folks,       Do we have any options to enable for rejecting the records from the source, if it is not adhered to the data type we have provided or the length is more or less than the defined one. Please let me know if any idea to implement the same.

score 5
Active 1 vote
Created on May 10, 2015 8:05 PM by Divya Panther - Last Modified: May 10, 2015 8:05 PM

Can we hear few Ideas of Data Integration used by you or in your project which you feel is recommeneded to others . Any kind Of Data Integration which starts from simple data loading technique to integrating two databases or schemas .

score 5
Active 1 vote
Created on Apr 17, 2015 2:16 PM by Girish Rathod - Last Modified: Apr 20, 2015 3:59 PM

We have data warehouse where data comes in and settles into the Fact . Our data hops over various stages and finally rests in the FACT later . For Instance , one of the flow of data can be Source -> Stage -> DW -> Dimentions Tables -> Fact Tables.   So now , given a column C1 in any Fact Table , say F1 , I need a way to find out this flow of data from all the way from Source to the Facr layer .   Something like below.               <- DIM1.C1  <- DW1.C1  <-  STG1.C1   <- SRC1.C1          …


Read More...

score 20
Active 4 votes
Created on Jan 14, 2015 11:35 AM by Ed Vel - Last Modified: Jan 14, 2015 11:35 AM

Hi All,   While comparing objects in a vresioned repository (or not) the version number is marked in red a Difference within the objects. Upon reviewing closely you might find out that the objects are identical with the exception of the version. It is a waste of time trying to discover the differences only because the version number is different.   Ed Velasco

score 0
Active 2 votes
Created on Dec 2, 2014 9:32 PM by Mehul Sorathiya - Last Modified: Dec 2, 2014 9:33 PM

Does anyone has idea how can we send an Email/Alert when Informatica throughput falls below a certain threshold?

score 0
Active 0 votes
Created on Nov 11, 2014 4:43 AM by varadharaj p - Last Modified: Nov 11, 2014 4:45 AM

Hi everyone,   I need to know whether incremental aggregation option is available in power center express edition.   If yes,provide me the document and also mapping source.

score 10
Active 2 votes
Created on Aug 6, 2014 1:25 AM by dussain kunipogu - Last Modified: Aug 6, 2014 1:27 AM

hi anybody tell me reasonable solution for this situation   source==>Mongodb target====>Oracle database tool===>Informatica powercenter   how to connect and extract the data from mongodb to target oracle with using informatica powercenter is there any way to connect to mongodb or use any plugins or any way can you please explain

score 10
Active 2 votes
Created on Aug 5, 2014 11:08 PM by Venkata SubbaRao Bonthala - Last Modified: Aug 5, 2014 11:08 PM

Informatica,   Why don't create a informatica online server for practice, if provide like that lot of peoples can do the R&D and explain to the customers clearly. Once done the R&D will create some POC based on customer requirement and that is very helpfull for customer and they will decide for which tool needs to use for integration.   Recently i have faced a query in my organization.   "Customer needs to do the profiling through any licenced software, but i suggested them to choose informa …


Read More...

score 5
Active 1 vote
Created on Jul 29, 2014 11:29 PM by Suhas Ravindra - Last Modified: Jul 29, 2014 11:30 PM

Hi Viral / Raja Kumara,   Is there a way where we can perform the same task as that of the compare folders wizard in Repository Manager via the commandline?   Please do let me know if there is a command as such. This would help developers and administrators to quickly find out the differences between 2 different folders in powercentre and the log could then be emailed as suitable.   Thanks & Regards, Suhas

score 25
Active 5 votes
Created on Jul 6, 2014 9:05 PM by Viral Raichura - Last Modified: Jul 7, 2014 11:24 PM

Hi,   Can we have a tool that can generate reports based on PowerCenter Workflow / XMLs? The tool can generate reports on naming convention, Session and Workflow properties etch.   If this tool is made open source, it can be tweaked by the community users and can be improved over the period of time.

score 15
Active 3 votes
Created on May 28, 2014 1:58 PM by hari prasad pulluru - Last Modified: May 28, 2014 1:58 PM

Why we need to validate , refresh the mapping when any changes are done in designer. We need to have a option to validate all the depenedent objects when a mapping is changed.

score 15
Active 3 votes
Created on May 19, 2014 8:22 AM by Samantha Seymour - Last Modified: May 19, 2014 8:22 AM

Create a marketplace block that will connect to two repositiories and perform an "info only" import of an xml. The output would be a report that contains a listing of the conflict resolution screens. It should include all entries including those that are Copy as well as those with Conflict. A blank column should included to use for turning over the Production team - this column could be used to indicate Replace/Reuse etc.

score 0
Active 0 votes
Created on May 14, 2014 4:46 PM by hari prasad pulluru - Last Modified: May 14, 2014 4:46 PM

Hi ,   I think we should have the SQ with capability to identify changed records based onthe provided column. Informatica internally does a minus and captures changed records with the given connection to check for the records.

score 0
Active 0 votes
Created on May 12, 2014 1:30 PM by Vikas Madaan - Last Modified: May 12, 2014 1:30 PM

I have a requirement where i need to read an xls file from MS Sharepoint. We could have used https transformation but at present it does not have the capability to read xls files from sharepoint. One of the ways to read an xls file from sharepoint may be to create custom java code and use that in java transformation.   Has any one faced such scenario. if not that it might be the way. I dont have the JAVA experties to create such a solution, if some one can create a such a solution and make it …


Read More...

score 0
Active 0 votes
Created on Feb 27, 2014 4:53 AM by Madhu Manya - Last Modified: Feb 27, 2014 4:53 AM

while creating lookup in informatica,i am getting the below error.please advise[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

score 0
Active 0 votes
Created on Jan 30, 2014 11:14 PM by Anjani Kumar Bonam - Last Modified: Jan 30, 2014 11:15 PM

We have Unicode CSV file as a source in our mappings, we are unable to access this file through informatica. Can anyone please let us know the code page setting to read Unicode CSV file?

score 0
Active 0 votes
Created on Jan 30, 2014 11:37 AM by Xitiz Pugalia - Last Modified: Jan 30, 2014 11:37 AM

It can be an opportunity for both the customers as well as the companies posting blocks for the Informatica Marketplace to use the Informatica tools most effectively if the top blocks of Marketplace are presented to the customers or mailed to customers on a regular intervals.

score 15
Active 5 votes
Created on Nov 27, 2013 4:52 AM by Saranya S - Last Modified: Nov 27, 2013 4:52 AM

Hi All,   It would be easy when informatica designer allow us to disable a pipeline if a mapping has more than a pipeline. When I am developing a mapping with multiple pipelines and I want to test a pipeline in that mapping, the disabling feature (disabling the other pipeines) will make the testing easier. Or when the mapping is prodution, and we dont want to run a pipeline for few days(i.e the pipeline loading a table and we doesnot want to load the table for few days), disabling the pipeline …


Read More...

score 15
Active 5 votes
Created on Nov 20, 2013 11:23 AM by charan gatla - Last Modified: Nov 20, 2013 11:24 AM

Currently if we want to use IN function in a expression or a router we are using as below..   IN(COL_NAME,VALUES) E.g. IN(CTRY_ID,'IND','AUS','ENG') This is applicable for strings   If we want to parameterize these values then we need to declare the a parameter $$PARAM, and declare it as IsExpVar as TRUE and pass values as $$PARAM='IND','AUS','ENG'   Even if we want to compare integer values means we are still doing the same.. i.e $$PARAM='1000','1001','1003','1004'   Why can't we declar …


Read More...

score 5
Active 1 vote
Created on Nov 14, 2013 1:34 AM by Saranya R - Last Modified: Nov 14, 2013 1:34 AM

Hi,        I have more number of mappings in each folder. And if i need to check the object (mapping/workflow) properties (Date modified) to find when the object got migrated/modified recently, i have to open each mapping and check the properties by right clicking the object. This process is very time consuming. So can we get the object properties into a single file using any unix commands?   It would be helpful if anyone suggest the ideas for this.

score 10
Active 2 votes
Created on Oct 21, 2013 1:30 AM by Snehal M - Last Modified: Oct 21, 2013 1:30 AM

Hi INFA Team, While working on huge mapping with more than 100 of links between transformation,it becomes really difficult to manage the links and there are chances that some of the links get deleted. Is there any way of freezing the unused code, so that one can easily work on the required part of code.

score 0
Active 0 votes
Created on Sep 11, 2013 3:23 AM by Anjani Kumar Bonam - Last Modified: Sep 11, 2013 3:32 AM

We have 60 mappings in the workflow and we hardcoded a value in all our mappings. Now I want to change the hardcoded value to Parameter. Can I export the workflow into XML file and replace hardcoded values directly in the XML file itself? Is this the correct approach?

score 0
Active 0 votes
Created on Aug 29, 2013 9:24 AM by Rajesh pulipati - Last Modified: Aug 29, 2013 9:29 AM

Hi  to all,     Please give me any idea regardin mantas behaviour. do you have any idea please forward the information this mail rajesh.infop@gmail.com other wise post proper information following post ...   Thanks in advance.   Rajesh

score 10
Active 2 votes
Created on Mar 18, 2013 4:12 AM by Debraj GHOSH - Last Modified: Aug 11, 2013 6:34 AM

It would be great if there is an option available to attache any DB Sequence to the Sequence Generator transformation in Informatica.   Suppose we have multiple source systems and related codes to load the data in a single Dimension table. We can use a Sequence Generator to load the SKs for this Dimension. Further we can make it REUSABLE to keep the SK sequencial and make a separate SK Generating Area. But, if two different seions using the same reusable Seq Gen, sometimes the Sequence Generato …


Read More...

score -5
Active 1 vote
Created on Aug 6, 2013 12:55 AM by Chetan Dhapudkar - Last Modified: Aug 6, 2013 1:05 AM

The Informatica Power Center Quick Strike Program shall help organizations to fine tune the performance of existing Informatica ETL loads, by scaling existing hardware and applications to provide outstanding performance and jointly scale to handle large volumes of data and users, in a quick turnaround time, based on its Complexity and Feasibility.

score 0
Active 0 votes
Created on Jul 25, 2013 7:23 PM by Dimitri Sakian - Last Modified: Jul 25, 2013 7:23 PM

Hi In scenarios we have to compare input string vs lookup table and get lets say 3 most similar records, we have to use JAVA Tx with HashTable and one of compare string algorithms methods (Like Levinshtein distanse, Soundex etc) or SQL SP script, The problem is that it usually running very slow and there is no corporate solution(one Truth).So on the same data, there is different resuls so it's hardly possible to establish pass threshold, So it make everybodies life easier if we will have b …


Read More...

score 10
Active 2 votes
Created on Jul 22, 2013 11:56 PM by Dimitri Sakian - Last Modified: Jul 22, 2013 11:58 PM

In the latest power center versions if we assign variable in mapping level, and using this variable in pre/post sesison sql commands (In target properties), the variables holds the previous session stored value in repository. It would by very handy if we could use new values assigned  in mapping's current session.       TY

Items per page
RSS feed of this list 1 2 Previous Next

Actions

Notifications