-
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...
-
What r the designer tools for creating tranformations?
Mapping designer Tansformation developer Mapplet designer
Sumithav29
- Jun 12th, 2009
A transformation is a repository object that generates, modifies, or passes data. We can create transformations in three ways:1. Transformation Developer - Used for creating reusable transformat...
chandrarekha
- Sep 7th, 2007
Mapping DesignerMaplet DesignerTransformation Deveoper?- for reusable transformation
-
How many ways you can update a relational source definition ?
Two ways 1. Edit the definition 2. Reimport the defintion
Read Best Answer
Editorial / Best Answer
Sumithav29- Member Since Jun-2009 | Jun 12th, 2009
1. If you want to make minor changes to the source definition, you can edit the source definition (in source analyzer) then the Designer propagates the changes to all mappings using that source.
2. If the source changes are significant, re-import the source and giving replace option while re-importing will reflect the changes in all the mappings where the source is used.Sumithav29
- Jun 12th, 2009
1. If you want to make minor changes to the source definition, you can edit the source definition (in source analyzer) then the Designer propagates the changes to all mappings using that source.2. If ...
gazulas
- Jan 30th, 2006
in 2 ways we can do it 1) by reimport the source definition 2) by edit the source definition
-
Turn Off Version
What happens if you turn off version?
sppavankumar
- Jun 9th, 2009
You would not be able to track the changes done to the respective mappings/sessions/workflows.
-
How to get the first 100 rows from the flat file into the target?
dl_mstr
- Dec 30th, 2007
Use a sequence generator set properties as reset and then use filter, put condition as NEXTVAL<=100 .
-
What is the use of Shared Folder?
toSudharsan
- Jun 9th, 2009
Shared Folder is like another folder but that can be accessed by all the users(Access can be changed), This is mainly used to share the Objects between the folders for resuablity. For example you can ...
Ram
- Nov 23rd, 2007
The Objects stored in the shared folder can be shared by the global users.I mean we can restrict one user not to access the contents of the folder by the priviliges of the folder.
-
Load Data to SAP R/3 System
How to load legacy system data into SAP R/3 (to ERP tables) for doing the data integration for legacy with R/3 System.
-
Unable to start Informatica Repository Service in Windows 2003
I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.i have windows server 2003 OSPlease, any one have a solution to this problem
krishna chaitanya
- May 11th, 2007
Problem with your userid and password.Missing repository installation files.
-
XML Transformation
Why do we need XML Transformation in Informatica?
DK_Reddy
- Apr 26th, 2009
1) Whenever we have Q systems, EAI sonorous we need XML transformation. 2) To handle unstructured data/semi structured data (.PDF) we need XML transformation. Because .PDF files had tags, Informati...
-
What r the mapings that we use for slowly changing dimension table?
Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data. Use the Type 1 Dimension mapping to update a slowly changing dimension table when you do not need to keep any previous versions of dimensions in the table. Type 2: The Type 2 Dimension Data mapping inserts both...
ASHOK1324
- Apr 21st, 2009
The Dimensions are classified 3 types.
1.SCD TYPE1 (Slowly Changing Dimension) : contains current data.
2.SCD TYPE2 (Slowly Changing Dimension) : contains current data + complete
historical data.
3.SCD TYPE3 (Slowly Changing Dimension) : contains current data + recent
historical data.
Rp
- Oct 4th, 2007
SCD: Source to SQ - 1 mapping, SQ to LKP - 2 mapping, SQ_LKP to EXP - 3 Mapping, EXP to FTR - 4 Mapping, FTR to UPD - 5 Mapping, UPD to TGT - 6 Mapping, SQGen to TGT - 7 Mapping. I thin...
-
What are the real time problems generally come up while doing/running mapping/any transformation?can any body explain with example.
gazulas
- Apr 22nd, 2009
All depends on your code.In general transformation errors like, date conversions, in-compatible data for a port. etc may arise at transformation level.
max
- May 9th, 2006
May be you will encounter with connection faliure, other then that i don't think so, cuzserver will handle all the syntex errors and Invalid mappings.
-
What r the types of lookup?
Connected and unconnected
gazulas
- Apr 22nd, 2009
Hey, what zaki told was correct.There are only two type: connected and unconnected.Mostly we use cache concept for connected, also only connected lkp will support SOME cache options.
zaki
- Apr 1st, 2007
Hello boss/madamonly two types of lookup are there they are:1) Connected lookup2) Unconnected lookup.I don't understand why people are specifying the cache types, I want to know that now a days caches are also taken into this category of lookup.If yes do specify on the answer listthankyou
-
What r two types of processes that informatica runs the session?
Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process. Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
ASHOK1324
- Apr 21st, 2009
Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process: Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
rasmi
- Sep 17th, 2007
When the workflow start to run,Then the informatica server process startsTwo process:load manager process and DTM Process;The load manager process has the following tasks1. lock the workflow and read ...
-
What is a command that used to run a batch?
Pmcmd is used to start a batch.
-
How can u recognise whether or not the newly added rows in the source r gets insert in the target ?
In the Type2 maping we have three options to recognise the newly added rows Version number Flagvalue Effective date Range
ASHOK1324
- Apr 21st, 2009
In the SCD Type2, we have three options to recognise the newly added rows: 1. Version number 2. Flag value 3. Effective Date Range
Prasath
- Oct 4th, 2007
Just use debugger to know how the data from source moves to target, it will show how many new rows get inserted else updated.
-
What is source qualifier transformation?
When U add a relational or a flat file source definition to a maping,U need to connect it to a source qualifer transformation.The source qualifier transformation represnets the records that the informatica server reads when it runs a session.
ASHOK1324
- Apr 21st, 2009
It is a transformation which is automatically generated to read the data from source tables into informatica designer.
jaber
- Dec 9th, 2007
Source Qualifier is a transformation with every source definiton if the source is Relational Database.Source Qualifier fires a Select statement on the source db.With every Source Definition...
-
Differences between connected and unconnected lookup?
Connected lookupUnconnected lookup Receives input values diectly from the pipe line.Receives input values from the result of a lkp expression in a another transformation.U can use a dynamic or static cache U can use a static cache.Cache includes all lookup columns used in the mapingCache includes all lookup out put ports in the lookup condition and the lookup/return port. Support user defined...
ASHOK1324
- Apr 21st, 2009
1]. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation.2]. Connected lookup can use ...
Shivat
- Sep 13th, 2006
Hi Differences Between Connected and Unconnected LookupsConnected LookupUnconnected LookupReceives input values directly from the pipeline.Receives input values from the result of a :LKP expressi...
-
How many ways u create ports?
Two ways 1.Drag the port from another transforamtion 2.Click the add buttion on the ports tab.
ASHOK1324
- Apr 21st, 2009
Ports are columns in Informatica Transformations.Ports can be created in 2 ways.1]. We can drag the ports from source qualifier to any type of transformation.2]. Double click on Header of Transofmrati...
Nitin Rane
- Jun 13th, 2007
We can copy and paste the ports in the ports tab
-
MainFrame to Informatica
How to Upload the MainFrame Source for Informatica ?
DK_Reddy
- Apr 19th, 2009
We got mainframe source as VSAM (Virtual Storage Access Method) files, mainframe developers converts these files as Flat files to access data into Informatica for our convenience. The bottom line is "The mainframe data files are in .Dat files(Flat Files)".
Informatica Interview Questions
Read Best Answer
Ans