-
-
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.
-
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.
-
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().
-
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?
-
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
-
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...
-
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 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
-
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)
-
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 ...
-
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 ...
-
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...
-
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.
-
-
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 ...
-
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 we remove the staging area
vikki_gupta2003
- Mar 14th, 2007
Hi,1)At DB level we can simply DROP the stagin table.2)then Create Target table at DB level.3) Directly LOAD the records into target table.NOTE: It is recommended to use staging area.
Prasad
- Jul 14th, 2006
hi,this question is logically not correct. staging area is just a set of intermediate tables.u can create or maintain these tables in the same database as of ur DWH or in a different DB.These tables w...
-
How can we eliminate source bottleneck using query hint
sreedhark26
- Mar 12th, 2007
You can identify source bottlenecks by executing the read query directly against the source database. Copy the read query directly from the session log. Execute the query against the source database w...
-
Informatica Interview Questions
Ans