-
-
Replace special characters
If you have column name as f_name in which the data is "john&","97edward","do__nna" . you want to remove/replace the special characters and then send the output as "john","edward","donna" to the target. what is the transformation and what is the function to be used in the mapping(informatica)
-
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 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...
-
How will you populate the time dimension table ?
Rohith Yogendra
- Apr 20th, 2007
CREATE OR REPLACE PROCEDURE TIMEDIMBUILD (p_start_date IN DATE, p_end_date IN DATE)AS v_full_date DATE; v_day_of_month NUMBER; v_day_of_year NUMBER; v_da...
Rohith Yogendra
- Apr 20th, 2007
Hi this would be the normal SP Code that i use to populate a time dimension,well again it depends on the business requirements to know what level the Grain is required for a time dimensionCREATE OR RE...
-
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
-
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) ...
-
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 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.
-
Informatica job via UNIX script problem
I am getting following error when i tried to run Informatica job through a UNIX script.The error is ERROR: Invalid user name or password.WARNING: Lost server connection.The user name and password is correctly entered and there is no discrepancy regarding that.The Unix log file says2007 OPALD31_LOAD_PLINK_ANNUALSTATEMENT.ksh FATAL ERROR - Session Failed, batch w_m_OPAL_PLINK_Annual Statement_load_to_stage,...
-
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.
Informatica Interview Questions
Ans