-
Server will be disconnected
Hi, Every thing is fine .But my problem is in work flow monitor the server will be disconnected.Even thought both oracle and informatica are running
Rocksakthi
- Jul 5th, 2008
First you click my computer properties In the properties you click the computer name tab. IN the computer name tab you see the Full computer name that is your server name you should give that name (se...
hasim_geek
- Jun 6th, 2008
1/Check for your Machinename where your Informatica server service is running.2/check for the INformatica port in your Workflow manager is in Informatica server configuration.
-
What is the impact of versioning for an Informatica repository?
What is the impact of turning versioning on or off for an Informatica repository? What is the impact of versioning on an existing repository and the new repository, when adding a new repository to the repository server?Thanks, Deborah
adilshariff
- Jul 1st, 2008
1.Versioning is a one time and one way process on Informatica repository.2.No impact on both the exisitng and new reprository.Infact Versioning is advantage,it is help full in team based envirno...
Uma Bojja
- Aug 14th, 2007
Versioning on repository is irreversible. Once we choose to version its done.Let me know which version of informatica are you using.ThanksUma Bojja
-
Repository Backup
What is the extension used to store backup of repository?
-
Significant change in Version 8 of informatica
Hi all,I would like to know what are the key differences between PowerCenter 7 vs 8? Give one significant change version 8 is offering?
vivek1708
- Jun 30th, 2008
I have worked with Informatica 7.1 but haven't used versioning.Informatica 8 is surely bundled with versioning systemAlso adding headers in a text target file is also possible in Info-8 without specifying the same while installation (which is wat you do for informatica 7)
sekhar.sanaka
- Apr 24th, 2008
Transformation wise we have some new transformations have been introduces like SQL Transformation,HTTP etc.we have file append mode has been introduced for the first time in informatica 8 for flatfile...
-
Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.
prade
- Jun 26th, 2008
In case of a source based commit, the integration services generates a commit row from the active sources and writes the rows into the target. The number of rows processed from the "active source...
vivek1708
- May 11th, 2008
I dont think above written statement is correctMyunderstanding is that for source based commit: a session as soon as it reads 10k rows from the source it performs a commitand similarly for tbc: as soon as it write 10k rows to targt it does a commit
-
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can u map these three ports directly to target?
NO.Unless and until u join those three ports in source qualifier u cannot map them directly.
prade
- Jun 26th, 2008
Sources from heterogenous databases cannot be pulled into a single source qualifier. They can only be joined using a joiner. And then can be written to the target
Vani_AT
- Apr 2nd, 2008
I don't think dragging three heterogeneous sources in a single source qualifier is valid. Whenever we drag multiple sources in same source qualifier, 1. There must be a joining key between the tab...
-
In a sequential batch can u run the session if previous session fails?
Yes.By setting the option always runs the session.
prade
- Jun 26th, 2008
Yes you can. Start ---L1-------> S1 --------L2-------> S2suppose S1 fails and we still want to run S2, then L2 condition --> $S1.status = FAILED or $S1.status = SUCCEEDED
-
Can we Use PACKAGES in Informatica mapping?if yes, How?
nandu214
- Jun 17th, 2008
Yes same as store procedure and one advantage of packages is it has overriding facility for this first we create package and store it in database before running the mapping
Kadhirvelu
- May 12th, 2008
Hi,what kind of packages ? are you talking about Oracle PL/SQL packages, the answer is yes. In fact, you can use Stored Procedures, Stored functions. And in the same way, you can use Packages.
-
How to use incremental loading when you load data from staging?
nandu214
- Jun 17th, 2008
HiFirst u run initial laod with startdate and enddate next take enddate as startdate for incremental loading it wil add the data for previous like this we can do incremental loadingHope this helps
-
How can we calculate the fact table size?
nandu214
- Jun 17th, 2008
Hi we can calculate the size depending upon how much period and how many products for how many customers information u want to store like this we calculate the fact table size.Ex:- if we have 100...
-
How to run a workflow without using GUI i.e, Worlflow Manager, Workflow Monitor and pmcmd?
-
Delete Informatica repository
I am using Informatica 7.1.1, How to delete the existing repository, mappings?
hasim_geek
- Jun 6th, 2008
To delete repository- Delete it from Informatica Server Administrative ConsoleTo delete Mapping - Delete it from designer.To delete folder - Delete it from Repository Manager.
-
-
What is the economic comparision of all the Informatica versions?
ggazulas
- May 27th, 2008
Economic comparision is nothing but the price-tag of informatica available versions.
-
In case of use of dynamic lookup cache in a lookup transformation, the lookup cache gets updated first and then the target table. What happens if the target table rejects a row after it is updated in the Cache?
ggazulas
- May 27th, 2008
You wont get an error if the row is inserted in dynamic cache and it was rejected in the target table. But remember we are refering to the same table in dynamic chache, so if it is inserted in the cha...
prakash
- Nov 26th, 2007
Data in the target table does syncronize. here you wont get any error but the result will not so accurate. so update it in the trg or you can use update strategy transformation as insert after lookup
-
How to assign session/workflow to a particular SERVER?
How to assign a session/workflow to a particular SERVER? ( I have many servers, I want to assign one workflow to one server)
anupama2000
- May 26th, 2008
Go to assign server in the work flow manager and assign the particular server of your requirements.
-
What is dimension mapping and what is fact mapping?
anupama2000
- May 26th, 2008
Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions w...
Raja
- Jun 1st, 2007
Dimension Mapping: In any star schema, we need to load all the Dimension tables first, because they act like reference for Fact,Fact mapping: there is dependency for Fact, which looks up for the Dimen...
-
Informatica's connect for SAP R/3
How to connect Informatica's with SAP R/3?
anupama2000
- May 26th, 2008
It is due to wrong server connection, try to assign server correctly because the IP address what you are using may change, so try to resolve IP address in work flow manager -> assign server configuration.
anupama2000
- May 26th, 2008
The Lan connection might have changed or check the net8 configuration setup .
-
When i try to connect to the repository server i am getting this message can someone help me..Starting Repository [infa_rep](6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit.(6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.(6016|1292) Informatica Repository Agent starting up.(6016|1292) Security audit trail has been turned off.(6016|1292) infa_rep: Repository runtime manager initialized.(6016|1292) infa_rep: Initialized configuration information.(6016|1292) infa_rep: Initialized request dispatcher.(6016|1292) Database Connection Error : Failed to logon to Database serverORA-12154: TNS:could not resolve service nameDatabase driver error...Function Name : ConnectDatabase Error: Failed to connect to database using user [] and connection string [].(6016|1292) Service stopped.
anupama2000
- May 26th, 2008
Go to the mapping designer check the source username, after that go to session task double click on it go to mapping tab, check the source connection if the name that is mentioned in this tab is not same as the user name what you have used as source change it to that.
sathishkumar_sundaram
- Nov 7th, 2006
Hi,If you look at the last few lines of the error message,ORA-12154: TNS:could not resolve service nameDatabase driver error...Function Name : ConnectDatabase Error: Failed to connect to database usin...
-
What is the need for an ODS(operational data store)
What is the need for an ODS(operational data store) in data warehousing?What are the advantages of using an ODS?
anupama2000
- May 26th, 2008
The need for ODS is to clean the data coming from hetrogenous sources. To maintain data quality for better warehouse which provides good reporting.
pal.amol
- Mar 1st, 2008
The Data cleaning tool name which is been widely used unliked Informatica (ETL tool ) name is FirstLogic.
Informatica Interview Questions
Ans