-
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.
-
Test and Debug in Informatica
How to Test and Debug in Informatica
-
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 ...
-
Custom Transformation
How to write custom transformation?
-
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
-
Connect MYSQL DB to Informatica
How to connect MySQL Database to Informatica PowerCenter
-
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
-
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 ...
-
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.
-
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...
-
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.
-
How can u stop a batch?
By using server manager or pmcmd.
VEMBURAJ.P
- May 28th, 2007
By using menu command or pmcmd.
-
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...
-
Can u start a session inside a batch idividually?
We can start our required session only in case of sequential batch.in case of concurrent batch we cant do like this.
Vani_AT
- Apr 1st, 2008
Yes, we can do this in any case. Sequential or concurrent doesn't matter.Ther is no absolute concurrent workflow. Every workflow starts with a "start" task and hence the workflow is a hybrid.
-
What is meant by source is changing incrementally?
What is meant by source is changing incrementally?Explain with an example?
N SRIRAM K
- Apr 14th, 2008
The data in the source is not STATIC..It may change (the no. of records - addition or subtraction) over the period of time or Session run to session run....ThxSRIRAM N
Vani_AT
- Mar 28th, 2008
I think, source is changing incrementally means new rows are getting inserted into the source. For example, If a source on day1 has 10 records; then on day2, 5 new records got added along with the pre...
-
What is intermediate task in informatica? In what situation this task will be executed?
-
Why do we need two connections for source? One is designer and another one is workflow manager? What is difference?
deeptisa
- May 2nd, 2008
The first one will be for the debugger in designer. And the other one is for the session in workflow manager.
-
Informatica Dynamic Source and Target
Similar to creating dynamic target can we create dynamic source?
-
Use VSAM file as Target in Informatica
Is it possible to have VSAM file as target? If yes can you suggest me how this can be done?
aniban
- May 10th, 2008
I believe (although not 100% sure) that this is possible. Several years back in one of the projects we had used a tool called STRIVA which could directly read/write in the form of VSAM files. Lately I...
-
Transfer data from xls and ms-access to oracle
How we can transfer data from ms-excel, ms-access to oracle through informatica ? whether it is possible?
aniban
- May 10th, 2008
Both are very much possiblew/ INFA: Write a mapping with src as Excel (or Access) and tgt as Oracle. Note: if your Informatica server is on UNIX, you need to save the XLS as csv and use that.w/o ...
vivek1708
- May 8th, 2008
Ya this is possible. For higher versions of oracle 10g onwardsthis can be done in 2 ways1) without using informatica --MS excel - This can be directly imported into oracle --MS access - Us...
Informatica Interview Questions
Ans