-
What is ODS ?what data loaded from it ? What is DW architecture?
crishnathk
- Dec 12th, 2006
thq from ur answer i can come to one conclusion tht ODS is used to store the current data.i can assume tht by defalut it will add tht 40000 records to this current data 10000 records n gives the reslut 50000.cud u plz reply to this......thq...
Sravan Gopisetty
- Sep 24th, 2006
ODS is an Integrated view of Operational sources(OLTP).
-
What is the basic language of informatica?
pradeeshkumar
- Aug 19th, 2010
The Informatica's basic Language is SQL(Structered Query Language). It generates sql queries and that is executed against the database.Informatica is just a tool, that generates SQL queries based on the conditions you specify.
Sravan Gopisetty
- Sep 24th, 2006
The basic language of Informatica is SQL plus.Then only it will under stand the data base language.
-
Which transformation has the most complexity Lookup or Joiner?
pradeeshkumar
- Aug 19th, 2010
Its not that complexity associated with the transformation. Its just how far you know to use which transformation is suitable for solving a problem.
sai
- Feb 14th, 2007
Lookupbut it will reduse the complexity of the solutions and improves the performance of the workflows.
-
-
What is sql override where do we use and which transformations
vishal
- Feb 16th, 2007
We use sql override for 3 transformationswhen the source is homo genious1. joiner transformation2. filter transformaton3. sorter transformation
sn3508
- Oct 26th, 2006
Besides the answers above, in Session properties -> transformations tab -> source qualifier ->SQL query - by default it will be the query from the mapping. If you over write it, this is also called 'SQL override'
-
1. what is DTM process?2. what r the output files that informatica creates during the session running?3. limitations of joiner transformations?under which conditions we can't use joiner transformation?
lakshmi1
- Oct 16th, 2006
HiWe can not use joiner when:1) both pipelines come from the same source2) both pipelines come from the same normalizer3)If one pipeline contain an update strategy or a sequence generator ( connected/unconnected )Regardslakshmi
-
What is the difference between Informatica server, Repository Server and Power center Server ?
Can any one explain clearly the difference between Informatica server, Repository Server, Power center Server ?
latha.c
- Apr 16th, 2010
Informatica is company name and Power Center is its product. Its advantage is build it once and deploy it anywhere. In Informatica Architecture we have 3 major components called 1. Client to...
akmohanty
- Feb 14th, 2007
Both the Informatica Server and Power Centre server are same meaning in Informatica.Its working to work proceedings for sessions and workflows in workflow Manager windows.The Repository server of Inf...
-
What is the difference between the power center 7x and power center 8x
dheena
- Mar 16th, 2007
Hi! 1) The first thing is 8x was not power centre it was power engine.2) In 8i, custom transformation was also available, it was in both active and passive so they released in 8i
akmohanty
- Feb 14th, 2007
Both are two versions.But in Infromatica 8x its possible to integrate java program but Its not possible in Informatica 7x to integrate java programs.
-
What is granularity in INFORMATICA? How should be the level of granularity for a fact table as well as for a dimension table?
P.Sivakumar
- Sep 12th, 2007
Granularity is a lowest level of information stored in databse that is called as granularity.
-
What is key factor in BRD?
prashant.baranwal
- Sep 19th, 2010
BRD: Business Requirement Document.key factor could be, understanding of business in terms of design logic.
-
$ symbol
$, $$, $$$ what these symbols represents in Informatica?
prashant.baranwal
- Sep 5th, 2010
$ is Session Parameter, Ex: $DBConnection$$ is mapping Parameter/Variable, Ex: $$LastRunDate$$$ is system variable, Ex: $$$SessStartTime
saravanakumar.ashokan
- Aug 29th, 2010
single $ denotes System variableDouble $$ denates User-defined variableTriple $$$ denotes Session Varaiables..You can read on mapping parameter & varaiable in de...
-
How do we estimate the depth of the session scheduling queue? Where do we set the number of maximum concurrent sessions that Informatica can run at a given time?
say2joshi
- Apr 24th, 2007
Hiwe can set the max no of concurrent session in informatica service. by default it is 10 sessions.thanks
pavithra
- Dec 17th, 2006
Hi,we set in informatica server where we have option called 'max. no of concurrent session '
-
What r the active and passive transforamtions?
An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it.
avneeshrathor
- Nov 3rd, 2009
Thats not correct. By this definition Update Strategy should be a passive transformation but it is not.So correct answer is that any transformation which can change 1. Number of rows 2. Row type i.e. DD_INSERT, DD_DELETE... 3. Transaction control... All these are active ones.
sasi.a.kumar
- Aug 14th, 2009
Passive Transformation: When the number of input records to a transformation is equal to the number of output records from the transformation then we call that transformation as Passive Transformation...
-
What is the look up transformation?
Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.
Sridhar Tirukovela
- Jan 2nd, 2007
Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which...
sithusithu
- Jan 19th, 2006
Use a Lookup transformation in your mapping to look up data in a relational table, view, or synonym. Import a lookup definition from any relational database to which both the Informatica Client and Server can connect. You can use multiple Lookup transformations in a mapping.Cheers,Sithu
-
What r the types of lookup?
Connected and unconnected
gazulas
- Apr 22nd, 2009
Hey, what zaki told was correct.There are only two type: connected and unconnected.Mostly we use cache concept for connected, also only connected lkp will support SOME cache options.
zaki
- Apr 1st, 2007
Hello boss/madamonly two types of lookup are there they are:1) Connected lookup2) Unconnected lookup.I don't understand why people are specifying the cache types, I want to know that now a days caches are also taken into this category of lookup.If yes do specify on the answer listthankyou
-
Which tool U use to create and manage sessions and batches and to monitor and stop the informatica server?
Informatica server manager.
ram_infa
- Sep 12th, 2011
Workflow manager is used to create,manage sessions and batches
Workflow Monitor is used to monitor, abort/stop the sessionsKarthikeyanVCSS
- Jun 30th, 2011
Informatica Server Manager - Tool that we are using to create and manage Sessions and Batches.
-
Can u copy the batches?
NO
Vani_AT
- Apr 1st, 2008
There is a slight correction in the above answer.We might not be able to copy the overriden (wrote overwritten in above answer) properties
Vani_AT
- Apr 1st, 2008
It should be definitely yes.Without that :1.the migration of the workflows from dev to test and to Production would not make any sense2. For the similar logics, we have to do same cumbersome jobThere ...
-
Performance tuning in Informatica?
The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performance of the Informatica Server is related to network connections. Data generally moves across a network at less than 1 MB per second, whereas a local disk moves data five to twenty times faster. Thus network...
srinivas
- Oct 4th, 2011
Your approach to that question and answer is perfect and correct
ankitmohansharma
- Jan 13th, 2008
Hey, Thank You so much for the information. That was one of the best answers I have read on this website. Descriptive yet to the point and highly useful in real world. I appreciate your effort.
-
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...
-
How do you migrate from one environment to another like development to production in Informatica. Which files do you move?
sandeepsandeep
- Aug 11th, 2014
Yes, everything is correct. there is also one other thing, you also have to move parameter files. if you forget your mappings will error out. and also you also need to change the values like dev qat s...
Mushi
- Jun 30th, 2014
First - Take a backup and restore of the repository using the Informatica Repository Manager console. Migration can be done at 3 levels: 1.Repository level , 2.Folder level , 3.Object level Steps fo...
Informatica Interview Questions
Ans