-
-
What is associated port in look up.
vizaik
- Mar 25th, 2007
Whenever you are using scd2, you have to use dynamic cache, then one port must be specified for updating in cache, that port is called associated port.
kirangvr
- Feb 1st, 2007
When you use a dynamic lookup cache, you must associate each lookup/output port with aninput/output port or a sequence ID. The PowerCenter Server uses the data in the associatedport to insert or updat...
-
How to have look on all lookups that are used in informatica mapping?
rsannu2k
- Jun 7th, 2007
two ways.1. go to navigation panel, under the mapping expand the Transformations folder, will list all the transformation including lookups... 2. but if you want to lookup and browse through only look...
SRIRAM N
- May 17th, 2007
You can have look on all the look-ups that are avialable in a mapping through,???????????? Workflow--> session --> EDIT (and look in MAPPINGS tab)
-
What is the use of odbc.ini file while installing server?
nitin_2002786
- Jan 24th, 2013
ODBC.ini file has the entry of drivers required for the third party software like sybase, Teradata etc. Its located at server/bin loc.
priyank_divya
- Jul 9th, 2012
Odbc.ini file is used to define the connections(DSN names,tcp/ip port) for database through which Informatica connects to the database.
-
What is the difference between Enterprise data warehouse and a data warehouse ??Which all transformation uses the cache directory ?
jryan999
- Sep 1st, 2008
I quite agree with the Enterprise Vs Departmental warehouse. Some background through.The two primary warehouse architectures are proposed by Kimball and Inmon. Inmon used to recommend a sin...
Shashikumar
- Jun 21st, 2007
EDW & DW are one & the same. If scope of data warehouse is enterprise wide it is called Enterprise data warehouse.If the scope of data warehouse is limited to department it is called Data mart.Transformation which uses cache are,Lookup,Joiner,Aggregator,Rank
-
How can we access MAINFRAME tables in INFORMATICA as a source ?
ex-: Suppose a table EMP is in MAINFRAME then how can we access this table as SOURCE TABLE in informatica?
latha
- May 29th, 2007
Use the Normalizer transformation to take the Mainframe sources(COBOL)
vishnukirank
- May 26th, 2007
Use Informatica Power Connect to connect to external systems like Mainframes and import the source tables.
-
How we can validate all mapping at a time?
We can validate all mappings in PowerCenter Repository Manager window by each folder.
Mahendra Rajpoot
- Sep 18th, 2014
Please use this link:
http://www.bullraider.com/database/informatica/scenario/27-informatica-scenario19
gives step by step appoachlakshmi
- May 27th, 2012
in repository go to menu tool then queries.query browser dialog box will appear.then click on new button. in query editor,choose folder name and object type after that execute it(by clicking the blue...
-
-
-
Explain Session Recovery Process?
sridhar39
- Dec 29th, 2007
hi, when the informatica server starts a recovery session it reads the opb_srvr_recovery table and notes the r...
chandrarekha
- Sep 28th, 2007
You have 3 steps in session recoveryIf Informatica server performs? no commit, run the session againAt least one commit, perform recoveryperform recovery is not possible, truncate the target table and run the session again.Rekha
-
What is redo log file in Informatica ?.
Suhel Shaikh
- Apr 4th, 2012
There is no redo log file in informatica.Its in oracle.
-
What is the Bridge Dimension?
VVM.SP
- Mar 17th, 2008
It is a intersection table between a dimension table & fact table with a multipart key capturing a many-to-many relationship
venu adavelly
- Sep 18th, 2007
A dim shared by two or more schemas nothing but bridge dim.venu adavelly
-
What is the meaning $, $$, $$$ in Informatica
THEJASWINI
- Sep 1st, 2007
$ - These are the system variables like $Bad file,$input file, $output file, $DB connection$$ - user defined variables$$$ - $$$SessStartTime $$$SessStartTime returns the initial system date value on t...
N SRIRAM K
- Aug 27th, 2007
Generally, As I know. $ refers Session Parameters like $source,$target. $$ refers Mapping Parameters like $$State,$$Time. $$$ refers System Parameters like $$$SessStartTime. I am requesting any other in pool Please check & let me know if I was wrong.
-
Could any one please tell me how informatica behaves in the following situation?(Let me explain you with example: I have following expression in a mapping I would display either FAIL or PASS status to a record.RESULT=IIF((A > (100 - B))OR(C > (100 - D))OR(E0) , 'FAIL', IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))Where the following variables are decimalsA (Decimal(9,2)) = 2.0179896789716073791692725900792e-5B(Decimal(9,2)) = 99C(Decimal(9,2)) = 50D(Decimal(9,2))= 99E(Decimal(9,2))= 0F(Decimal(9,2))=2681.75Problem is that system is showing FAIL but expected to be PASS.How the systems behaves with exponent values?1) would informatica drops the exponent and takes 2 as 'A'2) takes exponent (A) as is (0.00%)
vamannam
- Apr 12th, 2010
I think you have to use below expressionIIF ( (A > (100 - B)),'FAIL', IIF( (C > (100 - D)),'FAIL', IIF((E<= F AND F>0), 'FAIL', IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))))Regards,Vamsi
-
-
What are the main issues while working with flat files as source and as targets ?
Vani_AT
- Mar 28th, 2008
1. We can not use SQL override. We have to use transformations for all our requirements2. Testing the flat files is a very tedious job3. The file format (source/target definition) should match exactly...
rasmi
- Feb 6th, 2008
We need to specify correct path in the session , and mension either that file is 'direct' or 'indirect'. keep that file in exact path which you have specified in the session .-regards,rasmi
-
What is the difference between source definition database and source qualifier?
madhu.tella
- Mar 25th, 2010
Source definition in database is simply the table definition, but the source qulifier is one of the transformation in informaitca from which we can specify the data selection criteria to the database....
vemurisasidhar
- Sep 24th, 2007
A source definition database contain the datatypes that are used in the orginal database from which the source is extracted. where the source qualifier is used to convert the source definition datatypes to the informatica datatypes. which is easy to work with.
-
What are the locks with respect to mappings?How do you manually lock or unlock the mappings for chages?
ramachchandran
- Sep 14th, 2010
In Informatica locks are automatically created. to manually lock or unlock. Go to the admin console, select a repository and click the lock tab. using that you can create lock and release lock if al...
Pandit
- Oct 18th, 2007
If your PowerCenter repository is version-enabled, then you need to check-out /check-in in order to modify any objects (incl.. mappings). This is how you do the version control and locking on objects...!
-
Would you recommend using an orderby clause as part of a lookup sql override for a cached lookup data set in informatica
vemurisasidhar
- Sep 26th, 2007
if u use order by clause in the lookup it improves the performance. because system generated order by consists all the lookup ports in the orderby clause. instood use ur own order by clause. so that the input data can be sorted by the way u likeex. order by deptno--
chandrarekha
- Sep 24th, 2007
No ,It decreses the performance
-
Repository has been shutdown error
[09/23/2007 11:34:53] (Alert) Repository gowtham has been shutdown. I am getting error like this in services informatica repository server is starting but informatica is not starting pls help in this thanks and regards gowtham
prasad1507
- Dec 11th, 2007
Please check whether u have correct user privilege in windows to start services. You should have service start privilege in windows. One more thing Informatica server will be started and alive only any workflow is created.If this doesnt help, come back with exact details of your problem
vemurisasidhar
- Sep 26th, 2007
i think u need to restart tje services again. before that check all the configurations. like repserver,server,repository admin management console.
Informatica Interview Questions
Ans