- 
                    Error: OBJM_54538 with informatica powercerterCould not execute action... 
 
 The Service Name_repository could not be enabled due to the following error: OBJM_54538 - Unable to connect to the repository Name_repository on database mailto:DESKTOP-4FVDDK@IPC.error: OBJM_54538
 
 Please could you help me with this issue?
- 
                    Add/Modify Column Changes in Facts and DimensionsHow often do you get Add/modify column changes in Facts and dimensions? 
 
 Could you please give me couple real time Datawarehouse Project specific (Day to day work) scenarios?
 
 
- 
                    Informatica High Availability checkHow to check if the Informatica Power Center is highly available? 
- 
                    Wants to change career into InformaticaHi 
 
 My name is amit and i am here to take some career advice.
 
 I did Bsc (H) CS from delhi university in 2009 and after it i joined a company where my profile was Analyst in Excel and some basic use of SQL query. I worked there almost 3.8 yrs but due to some personal reasons i quit my job on september 2013 and now i am idle for last 4 months.
 
 Now i wants to switch...
- 
                    Repository Services not startedI have oracle 9i and windows XP installed on my machine and try to install informatica 8.6 and after successfully installing client and server try to do all setting in Power Center Administration Console and create new repository but repository services are not up and giving error that Unable to connect to the repository Repo on database TEST. 
 
 TEST is the SID on my machine
- 
                    ETL developer daily routine and reporting hierarchyCan anybody plz explain what would be the daily routine and reporting hierarchy of an ETL developer in sales project... 
- 
                    IT Advisory in the BIG FOURSHi all! I am a fresh graduate in Nigeria, looking forward to working with one of the big fours soon as a member of the IT advisory team, what IT tools would you advice I get acquainted with while I work towards my recruitment, secondly, can someone please enlighten me on the areas of ERP I need to take interest in, in order to perform on the job? 
- 
                    Cumulative sum using Java TransformationHow to find cumulative sum using JAVA Transformation? 
 
 Consider the following employees data as source
 
 employee_id, salary
 10, 1000
 20, 2000
 30, 3000
 40, 5000
 
 The target table data should look like as
 
 employee_id, salary, cumulative_sum
 10, 1000, 1000
 20, 2000, 3000
 30, 3000, 6000
 40, 5000, 11000
 
- 
                    How to generate a file based on location.Hi, 
 
 I have a requirement and I have created a mapping and I need to generate a single file based on location.
 
 ex:
 My server placed into us location and I will kick of my wf from uk so I need to create a uk file.
 
 col1 col2 location
 aaa bbb UK
 xyz ccc UK
 
 If I ran my wf from US location the out put file should be
 
- 
                    Informatica PowerExchange Release Date?Could any body reply me, when the PowerExchange was first released in the market? Was it with Informatica 7.x versions? Please reply. Thank you. 
 
 Kumar.
- 
                    How would you explain about Informatica Project ?Can any one please tell me how to explain Data warehouse project in interview and from where to start and end. what to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.what is data warehouse methodology ,types of dw methodology, most using dw methodology in companies... 
- 
                    Pull data from SAP Financials using InformaticaHi, I want to know the processes for pulling the data from SAP Financials using informatica and write scripts to locate the required data.Thank you. 
- 
                    How to pull the dataHi,How to pull the data from XML and flat files in informatica?How to pull the data from Materialized view in informatica? 
- 
                    Session Termination ErrorWhat is session termination? Why does this error occur? 
- 
                    Router Trasmission Logic ExpressionWhat are the logic expression used in router trasmission? 
- 
                    DTM ProcessWhat is DTM Process? 
- 
                    Target Flat Files Header and FooterHow to create header and footer in target flat files? 
- 
                    Informatica Loop ScopeHow to perform a "Loop Scope / Loop condition" in an Informatica program ? Give me few examples. 
- 
                    Workflow DependancyWhere do we set the dependancy in the workflow? 
- 
                    Shared FolderHow to use shared folder objects? 
Informatica Interview Questions

 
  
  
  
		
Ans