-
-
Star Schema
How many star schemas can you use in a project? Is it possible to use more one star schemas?
-
Metadata Repository
Is metadata repository informatica a file format or database format?
-
Time Dimension
How to load time dimension using Informatica?
laltho
- Aug 29th, 2010
My understanding is time dimension can be loaded by using stored procedure, No live project experience, got info from reading material.
-
Check Existing Rows in Target with Joiner
How to check whether rows existed in target or not by using joiner?
surinr
- Mar 18th, 2011
Use a lookup transformation and compare the target record with source record for existence of the record in the target table.
-
How do you change the transformation?
On one day there are 10 cities and the other day 5 more cities gets added? then how do you change the transformation? What do you do?
sppavankumar
- Jul 18th, 2011
If there is change in the data, there is no need to go for changing of the transformation. Instead you can insert/update the incremental data.
Please elaborate the question if not answered. -
What is Code Page used for?
Code Page is used to identify characters that might be in different languages. If you are importing Japanese data into mapping, u must select the Japanese code page of source data.
reshhhhhh
- Sep 23rd, 2010
The code page influences the way the application stores, recieves and sends the data. Code page is basically to convert any language to the language that the system understands.
-
What r the methods for creating reusable transforamtions?
Two methods 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation. Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time. If u change the properties of a reusable transformation in...
sithusithu
- Jan 19th, 2006
You can design using 2 methodsusing transformation developercreate normal one and promote it to reusable CheersSithu
Praveen Vasudev
- Sep 12th, 2005
PLEASE THINK TWICE BEFORE YOU POST AN ANSWER.Answer: Two methods 1.Design it in the transformation developer. by default its a reusable transform.2.Promote a standard transformation from the mapping d...
-
What r the rank caches?
During the session ,the informatica server compares an inout row with rows in the datacache.If the input row out-ranks a stored row,the informatica server replaces the stored row with the input row.The informatica server stores group information in an index cache and row data in a data cache.
venkat2ram
- Apr 11th, 2014
Rank caches are the caches created to calculate the rank while session run for Rank transformation. Index cache and Data cache Index cache stores the values of the key column i.e. rank port here. D...
-
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.
Informatica Interview Questions
Ans