-
-
Can anyone please explain how i can write a subquery in the expression editor of a filter transformation (i need the syntax to write in the expression editor)thanksnayana
sreenivasareddy.aug10
- Jul 10th, 2009
You could not write the subquery in Filter editor. Because Filter editor is for specifying the conditions only. You can write the? subqueries in by source qualifier. There you can use the filter condition as well as write the subquery and overide SQL you can archive.
Motilal
- Sep 12th, 2006
The subquery syntax is very similar to SQL.Still, you can see the navigator page in the left side of the editor page.we have ports,functions, etc there.you can double click on a fuction to find that funtion in your editor page.And the logic must be from you as obvious..
-
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 to remove 2 starting rows from my source flat flie
Rajesh
- Jan 31st, 2014
From Import Flat File Wizard, Edit the setting - Start Import At Row value as 3, that would skip/remove the first and second record and start importing from the third record.
-
Sorter transformation
If i enable select distince property in sorter transformation, on what basis the sorter tranformation removes the duplicate data
-
How to load fact table ?
tannya
- Dec 15th, 2006
Fact tables always maintain the history records,and mostly consists of keys and measures,So after all teh dimension tables are populated,teh fact tables can be loaded.The load is always going to be a incremental load except for the first time which is a history load.
hanug
- Dec 11th, 2006
HI:There are two ways u have to load fact table. 1. First time load2. Incremental load or delta loadIn both cases, u have to aggregate, get the keys of the dimentional tables and load into Fact.In case of increments, u use date value to pickup only delta data while loading into fact.Hanu.
-
What are Target Options on the Servers?
Target Options for File Target type are FTP File, Loader and MQ.
There are no target options for ERP target type
Target Options for Relational are Insert, Update (as Update), Update (as Insert), Update (else Insert), Delete, and Truncate Table.svivekananda
- Jun 26th, 2010
Relationals db: UPDATE, INSERT, DELETE, TRUNCATEFlat file: Dir / filename
MANOJ KUMARPANIGRAHI
- Feb 21st, 2007
Target option for Flat file,relational file (update ,Insert)
-
What r the mapping paramaters and maping variables?
Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session. When u use the maping parameter ,U declare and use the parameter in a maping or maplet.Then define the value of parameter in a parameter file for the session. Unlike a mapping parameter,a maping variable represents a value that can change...
chandrarekha
- Sep 12th, 2007
Mapping parameter represents a constant value defined before mapping run.
Mapping reusability can be achieved by using mapping parameters.
Mapping variable represents a value that can be changed during the mapping run.
Mapping variable can be used in incremental loading process.sithusithu
- Jan 19th, 2006
You can use mapping parameters and variables in the SQL query, user-defined join, and source filter of a Source Qualifier transformation. You can also use the system variable $$$SessStartTime. The Inf...
-
Can u use the maping parameters or variables created in one maping into any other reusable transformation?
Yes.Because reusable tranformation is not contained with any maplet or maping.
Prasad
- May 22nd, 2007
Hi, you can use the mapping parameters or variables in a reusable transformation. And when you use the xformation in a mapping, during execution of the session it validates if the mapping parameter that is used in the xformation is defined with this mapping or not. If not, the session fails.
mahesh4346
- Feb 2nd, 2007
But when one cant use Mapping parameters and variables of one mapping in another Mapping then how can that be used in reusable transformation when Reusable transformations themselves can be used among...
-
What r the joiner caches?
When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the caches, the Joiner transformation reads records from the detail source and perform joins.
bneha15
- Apr 23rd, 2007
For version 7.x and above :When the PowerCenter Server processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The...
sithusithu
- Jan 19th, 2006
Specifies the directory used to cache master records and the index to these records. By default, the cached files are created in a directory specified by the server variable $PMCacheDir. If you overri...
Informatica Interview Questions
Ans