-
What r the session parameters?
Session parameters r like maping parameters,represent values U might want to change between sessions such as database connections or source files. Server manager also allows U to create userdefined session parameters.Following r user defined session parameters. Database connections Source file names: use this parameter when u want to change the name or location of session source file between session...
Vani_AT
- Apr 1st, 2008
A small correction, it starts with single dollar symbol . double dollar symbol is used for mapping parameters.
Vani_AT
- Apr 1st, 2008
In addition to this we provide the lookup file name.The values for these variables are provided in the parameter file and the parameters start with a $$ (double dollar symbol). There is a predefined f...
-
How can u stop a batch?
By using server manager or pmcmd.
VEMBURAJ.P
- May 28th, 2007
By using menu command or pmcmd.
-
Can u start a batches with in a batch?
U can not. If u want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch.
-
What r the different options used to configure the sequential batches?
Two options Run the session only if previous session completes sucessfully. Always runs the session.
Vani_AT
- Apr 1st, 2008
I would like to make a small correction for the above answer.Even if a session fails with the above property set,all the following sessions of the workflow still run and succeed depending on the valid...
sn3508
- Aug 24th, 2007
You have to specify those options in the workflow designer. You can double click the pipeline which connects two sessions and there you can define prevtaskstatus=succeeded. Then only the next se...
-
When the informatica server marks that a batch is failed?
If one of session is configured to "run if previous completes" and that previous session fails.
Vani_AT
- Apr 1st, 2008
A batch fails when the sessions in the workflow are checked with the property"Fail if parent fails"and any of the session in the sequential batch fails.
-
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 ...
-
What are the main issues while working with flat files as source and as targets ?
Vani_AT
- Mar 28th, 2008
1. We can not use SQL override. We have to use transformations for all our requirements2. Testing the flat files is a very tedious job3. The file format (source/target definition) should match exactly...
rasmi
- Feb 6th, 2008
We need to specify correct path in the session , and mension either that file is 'direct' or 'indirect'. keep that file in exact path which you have specified in the session .-regards,rasmi
-
What is the Bridge Dimension?
VVM.SP
- Mar 17th, 2008
It is a intersection table between a dimension table & fact table with a multipart key capturing a many-to-many relationship
venu adavelly
- Sep 18th, 2007
A dim shared by two or more schemas nothing but bridge dim.venu adavelly
-
Migration of mappings
How do we move mappings from development environment to Testing environment and from there to production?
Noel Lastra
- Mar 5th, 2008
Export your mappings into XML, place it in your local folder then go the next environment and import the xml mappings you've exported.
pal.amol
- Feb 26th, 2008
Dear Friend,Migration of mappings are very delicate things. In this process you need to take backup of repository if it is test to QA and from QA to Production as you mentioned.Follow on i would like ...
-
Mapping variable - Mapping Parameter
What will happen when Mapping variable and Mapping parameter in Informatica is not defined or given? Where do you use mapping variable and mapping parameter?
garunchowdary
- Feb 29th, 2008
Definitely it accepts the defualt values when parameters or variables are not present.
sarun5
- Feb 18th, 2008
Thanks Deepak. But does it take any null values or any default values to run the mapping.
-
How to return more than two values from an unconnected lookup?
Amritendra kumar
- Feb 29th, 2008
Unconnected lookup only return 1 port but if you want to return 2 port then u have to play mind game mean u hav to use concatenate operator in expression editor.
-
Connect two sources
How to connect two sources with connecting field without using joiner and lookup?
-
Apply Business Rules
Where do we apply business rules from souce to staging or staging to warehouse?
Amritendra kumar
- Feb 29th, 2008
Actually we don't apply business rule . we only treat the data according to the business rule and in this work we get help by business analyst. in staging area we generally do cleansing ...
-
Informatica Mapping level Questions
in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?
Amritendra kumar
- Feb 29th, 2008
As per my openion it will insert only because it give preference to session
chandrarekha
- Feb 5th, 2008
It performs insert operation,because session overwrites the mapping level properties
-
Why cant we use more than two groups connecting the target in router transformation?
Amritendra kumar
- Feb 29th, 2008
My dear we can use more than two group in router transformation. it is the main purpose of router to define many condition. there is one default output also so if you are giving 4 condition there than output will be 5. and for this we need 5 target.hope it will help.thanks
sekhar.ganta
- Jan 3rd, 2008
we can use more than two groups connection the target . If you take emp table, for this we we have to take 3 targets,for the purpose of If sal
-
Sorter in Active Transformation
Why is sorter an active transformation? What happens when you uncheck the DISTINCT option in sorter?
MMSheriff
- Feb 27th, 2008
Sorter is an active transformation since it eliminate the duplicate records when the distinct option box is checked.The uncheck distinct option will lead to show duplicate records
-
Run sessions
How do you run sessions one after another?
pal.amol
- Feb 25th, 2008
There are two methods for running the session one is to run concurrently and second one is to run sequentially which you want to do. There are three things need to be configured at properties lev...
-
Informatica PowerCenter repository server configuration error - "the server could not contact" message
Hi, This is Ram working as a system administrator I had installed the Informatica PowerCenter 7.1.1 and when i was configuring the repository server it is giving "the server could not contact" message, I never faced this problem before pls anybody had any solution pls send to me as early as possible i tried all the possible ways to solve this problem but i could not get it so pls help me in this regard.
pal.amol
- Feb 25th, 2008
Hi Ram,You could first go to repository manager give relational connection and then you could configure server add new and give details.Give port name as defined in the configue repository serve...
akmohanty
- Feb 8th, 2007
At the time of configuring the repository server just give the port number is 5001 and put a passwordThen start the service first then open the repository server administrator console.Just connect it ...
-
What happens when the session stops half way while loading? How to join a flat file without matching keys in RDBMS?
Sreeya
- Feb 21st, 2008
For the 1st part, we can adopt the recovery options as given in the session property, using the recovery strategy.But using this in real time scenario has proved to take a toll on the performance.Anot...
Deepak Rajkumar
- Feb 18th, 2008
Not sure about session stops without loading. We can join flat files without matching coloumns by:1: use a Seq. Gen. and generate Pks and join using Joiner.
-
How do you use Normalizer to convert columns into rows ?
Deepak Rajkumar
- Feb 18th, 2008
Using Normalizer, in the normalizer properties we can add coloumns and for a coloumn we can specify the occurance levels, which converts rows into coloumns.
Informatica Interview Questions
Ans