-
How to do aggregation with out using AGGREGAROR Transformation ?
hemasundarnalco
- Mar 9th, 2007
Write a sql qurey to perform an aggregation in the source qualifier transformation
-
How do you store Historical data in a DWH ?
1.How do you store Historical data in a DWH?2.What is the primary purpose of using surrogate key? Will those be used in fact tables?If not then what is the purpose in using it?3. How do you update Information in Update strategy Transformation?4. How do you validate data after you have transferred it into target table from flat files?
vizaik
- Mar 15th, 2007
By using scd2, we can store historical data.Surrogate key is used for indexing purpose. i.e. as a primary key for a table. You can say that why can't we use primary key. But the ...
vizaik
- Mar 15th, 2007
By using scd2, we can store historical data.Surrogate key is used for indexing purpose. i.e. as a primary key for a table. You can say that why can't we use primary key. But the ...
-
-
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 are steps invovlved in connecting OLTP system to DATAWARE HOUSE to get the souce from OLTP system
vizaik
- Mar 22nd, 2007
Mr.,Go to source analyzerselect sources tab.select import from databases.it opens a child window which asks for username,password and connection name.there will be a button with '...' you pres...
-
Can anyone tell me how to create time dimension? Do we have to use type1,2,or3 for creating time dimension or we can just create it by using only expression transf and a date column from the source?Thanks in advance.
mithunmca
- Mar 23rd, 2007
hi the below procedure would create a time dimension in oracle --Procedure to calendar dimension type1, FROM the trancation file.CREATE OR REPLACE PROCEDURE cal_fileis-- Declare a pl/sql table t...
Asha
- Mar 5th, 2007
hi monica,we can create time dimension in 2 different ways1) using Oracle In oracle database, we have to create a procedure...to load the time and calendar dimension.By just executing EXEC ...
-
Explain about Informatica server process that how it works relates to mapping variables?
vizaik
- Mar 24th, 2007
First load manager starts the session and it performs verifications and validations about variables and manages post session tasks such as mail. then it creates DTM process.this DTM inturn create...
sreedhark26
- Mar 12th, 2007
The PowerCenter Server holds two different values for a mapping variable during a session run: Start value of a mapping variable Current value of a mapping variable Start Value The start value is the ...
-
How do you handle two sessions in Informatica
Can any one tell me the option between the two session . if previous session execute successfully than run the next session...
vizaik
- Mar 24th, 2007
you can drag and drop more than one session in a workflow.there will be linking different and issequential linkingconcurrent linkingin sequential linking, you can run which ever session you require or...
chsrikanth15
- Mar 2nd, 2007
Where exactly do we need to use?this link condition (id $ PrevTaskStatus = SUCCESSFULL)
-
What is inline view?
vizaik
- Mar 24th, 2007
Used in oracle to simplify queriesex: select rowid from (select ename from emp group by sal) where rowid<2
Hanu Ch Rao
- Feb 22nd, 2007
The inline view is a construct in Oracle SQL where you can place a query in the SQL FROM, clause, just as if the query was a table name.A common use for in-line views in Oracle SQL is to simplify complex queries by removing join operations and condensing several separate queries into a single query
-
What is use of event waiter?
sithu
- Mar 24th, 2007
Event wait: will hold the workflow until it is get other instruction or delay mentioned by the userCheers,Sithusithusithu@hotmail.com
sanghala
- Mar 9th, 2007
Event Wait task is a file watcher.when ever a trigger file is touched/created, this task will kick off the rest of the sessions to execute which are there in the batch.I used only User defined Event wait task.
-
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...
-
Why can't we use normalizer transformation in mapplet?
sreedhark26
- Mar 26th, 2007
HiNt is using for cobol sources, u can take data in source analyzer automatically displays normalizer transformation. u can not use in mapplet.sreedhar
-
Strategy Transformation
By using Update Strategy Transformation we use to maintain historical data using Type2 & Type3. By both of this which is better to use? Why?
-
How to parse characters using functions in the expression transformation. For example if a column has character like mgr=a. I have to parse the character 'mgr='. Which function should I use?
kanak3
- Mar 27th, 2007
Pal....We can not use charcode() function here.When you configure the PowerCenter Server to run in ASCII mode, CHRCODE returns thenumeric ASCII value of the first character of the string passed to the...
pal
- Mar 6th, 2007
Use chrcode().
-
Informatica Bulk Load Question
If flat files is your source. what are the option in session to take bulk of files from same folder have the same structure of all the files..
parambollina
- Mar 27th, 2007
For that you can select source file type as indirect and you have to specify that folder path at source file directory.
-
What is the difference between mapplet and reusable Transformation?
veera_kk
- Mar 30th, 2007
A set of reusable transformations is called mapplet where as a single reusable transformtion is called reusable transformation.
-
-
If a session fails after loading of 10,000 records in to the target.How can u load the records from 10001 th record when u run the session next time?
As explained above informatcia server has 3 methods to recovering the sessions.Use performing recovery to load the records from where the session fails.
ggk.krishna
- Apr 8th, 2007
Hi,We can restart the session using session recovery option in workflow manager and workflow monitor. Then the loading starts from 10001 th row.If you start the session normally, it starts from 1 st row.If you define target load type as "Bulk", session recovery is not possible.
-
What r the reusable transforamtions?
Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances...
devaranr
- Apr 12th, 2007
1. A reusable transformation can be used in multiple transformations2.The designer stores each reusable transformation as metada separate from any mappings that use the transformatio...
zaki
- Apr 1st, 2007
Hai to all friends out therethe transformation that can be reused is called a reusable transformation.as the property suggests it has to be reused:so for reusing we can do it in two different ways 1) ...
-
What r the types of maping wizards that r to be provided in Informatica?
The Designer provides two mapping wizards to help you create mappings quickly and easily. Both wizards are designed to create mappings for loading and maintaining star schemas, a series of dimensions related to a central fact table. Getting Started Wizard. Creates mappings to load static fact and dimension tables, as well as slowly growing dimension tables. Slowly Changing Dimensions Wizard. Creates...
raj
- Apr 13th, 2007
Inf designer :Mapping -> wizards --> 1) Getting started -->Simple pass through mapping &nb...
sithusithu
- Jan 9th, 2006
Simple Pass through Slowly Growing Target Slowly Changing the Dimension Type1Most recent values Type2Full HistoryVersionFlagDate Type3Current and one previous
Informatica Interview Questions
Ans