-
What r the types of groups in Router transformation?
Input group Output group The designer copies property information from the input ports of the input group to create a set of output ports for each output group. Two types of output groups User defined groups Default group U can not modify or delete default groups.
sithusithu
- Jan 23rd, 2006
A Router transformation has the following types of groups: Input Output Input Group The Designer copies property information from the input ports of the input group to create a set of output ports for...
phani
- Dec 9th, 2005
Input group contains the data which is coming from the source.We can create as many user-defined groups as required for each condition we want to specify.Default group contains all the rows of data that doesn't satisfy the condition of any group.
-
What are the types of data that passes between informatica server and stored procedure?
3 types of data Input/Out put parameters Return Values Status code.
Sumithav29
- Jun 12th, 2009
There are three types of data that pass between the Integration Service and the stored procedure: 1. Input/output parameters: For many stored procedures, you provide a value and receive a value in re...
-
What is the status code?
Status code provides error handling for the informatica server during the session.The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully.This value can not seen by the user.It only used by the informatica server to determine whether to continue running the session or stop.
venkat2ram
- Apr 11th, 2014
Status code is used to determine the status of the execution of the code. i.e. if you used command task, Informatica will post the command to OS and when it is completed the OS will return a status c...
-
What is Datadriven?
The informatica server follows instructions coded into update strategy transformations with in the session maping determine how to flag records for insert, update, delete or reject. If u do not choose data driven option setting,the informatica server ignores all update strategy transformations in the mapping.
Girish
- Aug 15th, 2006
When Data driven option is selected in session properties it the code will consider the update strategy (DD_UPDATE,DD_INSERT,DD_DELETE,DD_REJECT) used in the mapping and not the options selected in the session properties.
sithusithu
- Jan 19th, 2006
The Informatica Server follows instructions coded into Update Strategy transformations within the session mapping to determine how to flag rows for insert, delete, update, or reject. If the mapping fo...
-
Define maping and sessions?
Maping: It is a set of source and target definitions linked by transformation objects that define the rules for transformation. Session : It is a set of instructions that describe how and when to move data from source to targets.
-
What r the data movement modes in informatcia?
Datamovement modes determines how informatcia server handles the charector data.U choose the datamovement in the informatica server configuration settings.Two types of datamovement modes avialable in informatica. ASCII mode Uni code mode.
Sumithav29
- Jun 12th, 2009
The data movement mode is an Integration Service option you choose based on the type of data you want to move, single-byte or multibyte data. The data movement mode you select depends the followin...
-
In which circumstances that informatica server creates Reject files?
When it encounters the DD_Reject in update strategy transformation. Violates database constraint Filed in the rows was truncated or overflowed.
Sumithav29
- Jun 12th, 2009
By default, the Integration Service process creates a reject file for each target in the session. The reject file contains rows of data that the writer does not write to targets. The writer may reject...
-
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 is a command that used to run a batch?
Pmcmd is used to start a batch.
-
In a sequential batch can u run the session if previous session fails?
Yes.By setting the option always runs the session.
prade
- Jun 26th, 2008
Yes you can. Start ---L1-------> S1 --------L2-------> S2suppose S1 fails and we still want to run S2, then L2 condition --> $S1.status = FAILED or $S1.status = SUCCEEDED
-
What is difference between partioning of relatonal target and partitioning of file targets?
If u parttion a session with a relational target informatica server creates multiple connections to the target database to write target data concurently.If u partition a session with a file target the informatica server creates one target file for each partition.U can configure session properties to merge these target files.
-
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 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...
-
If a Mapping is running slow, What steps you will take, to correct it?
vinodh259
- May 11th, 2007
provide optimizer hints to the informatica. such as force informatica to use indexes, synonyms, etc ..best technique is find ehich trnsformation is makin the mapping slow and with that logic bui...
-
How do you load flat files of same structure into a target table?
imran.nabi
- May 30th, 2007
Hi,You can do it through file list. You have create a file containing path of all file. And u have to give that file name in session properties and select indirect.Thanks,imran
-
How to assign session/workflow to a particular SERVER?
How to assign a session/workflow to a particular SERVER? ( I have many servers, I want to assign one workflow to one server)
anupama2000
- May 26th, 2008
Go to assign server in the work flow manager and assign the particular server of your requirements.
-
What is the difference between SQL override in Source Qualifier and SQL override in Look up transformation.
g.nagaprasad
- May 22nd, 2007
In lookup transformation there is a default clause ORDER BY... but in case of Source Qualifier we have to give manually.
-
What types of Errors occur when you run a session, can you describe them with real time example
kasisarath
- Jan 25th, 2008
There are several errors you will get. Couple of them are1. if informatica failed to connect data base2. If source file not eixsts in location3. If paramerters not initilized with parameter file4. incompataible piped data types etc.
-
How to create slowly changing dimension in informatica?
hanug
- May 8th, 2007
We can create them manually or use the slowly changing dimension wizard to avoid the hassels.Use slowly changing dimension wizard and make necessary changes as per your logic.Hanu.
Informatica Interview Questions
Ans