-
What is the use of update override option in target properties?
Sumithav29
- Sep 3rd, 2009
Using UPDATE STRATERGY, we can update the target tbale based on ket columns. To update the target table based on non-key columns, we can use the update override option in the target.
-
Joiner Transformation Cache
What are the caches available in Joiner transformation?What is stored in Joiner cache(data cache) and Index cache?
Rashmirekha
- Sep 2nd, 2009
For Unsorted Input joiner transformation, i) Data cache stores all master rows in the join condition with unque index keys ii) Index cache stores all master rows.For Sorted Input with Different ...
raam.pt
- Aug 18th, 2009
Caches in JTR are 2.
1) Data Cache
2) Index Cache
1) Data Cache: It stores master source rows OS source table as configured in join condition.
2) Index Cache: It stores index values for master.
-
In your mapping using sequence generator transformation, the limitation of the transformation is it generates key values only around 2 million. If it is more than 3 million records are there in your source, how will you generate key values and load into target.
ravikumar.amudala
- Aug 26th, 2009
Now we dont have that problem, now sequence generator trans is have some around 18 digit number, so the problem is solved.if it extends more than that, go for stored procedure.RegardsRavi
ask_kaushik
- Dec 6th, 2007
use a Stored Procedure transformation where the stored procedure generates keys after checking the max in the target.
-
How three column in one table concatenated in Informatica?
How three column in one table concatenated in Informatica?When i am giving SAL || COMM || DEPTNO in exp it's failed to read during testing.By giving (CONCAT(CONCAT(SAL,COMM),DEPTNO)) i am also getting error during testing.
raj_infadev
- Oct 13th, 2008
In Informatica its better to use the symbols to make the operation faster cause Power Center Server can understand the symbols more easily than the function names....For Example: Concatenation operati...
-
Adding Values to a Column
How to add values to a column present in target file which column is not present in source file?
mythili.ki
- Jul 27th, 2009
Create a port in expression transformation and do calculation whatever you need for the target or assign default value for that port and just pass that to target.
jayanthidinesh
- Jan 7th, 2009
If the target column is coming as NULL value from source, You can give a default value by adding a column in expression transformation ad below.COLUMN_NAME (The datatype and value filed will populate....
-
Mapplet Transformations
What are the transformations not used in mapplet and why?
Read Best Answer
Editorial / Best Answer
gazulas- Member Since Jan-2006 | Jul 2nd, 2008
The following should not include in a mapplet.
- Normalizer transformations
- Cobol sources
- XML Source Qualifier transformations
- XML sources
- Target definitions
- Pre- and post- session stored procedures
- Other mapplets
The exact reason i why these should not used i dont know.
sahan
- Jul 16th, 2009
Normalizer transformationXML source qualifierXML filesOther targets.If
you need to use sequence generator transformation use the reusable sequence gen t/rIf
you need to use stored procedure transformation, make the stored procedure type as normal. -
Load the remaining rows
Suppose there are 100,000 rows in the source and 20,000 rows are loaded to target. Now in between if the session stops after loading 20,000 rows how will you load the remaining rows?
sahan
- Jul 16th, 2009
You can do it by performing session recovery.When you enable session recovery option, the integration service?makes the entries to opb_session_recovery table and notes the row id of the last row comm...
N SRIRAM K
- Apr 14th, 2008
How would you know whether the server commited or not? You can run the session again by setting the recovery opton enable and recover the session..which starts processing from the point where it was s...
-
Can anyone please explain how i can write a subquery in the expression editor of a filter transformation (i need the syntax to write in the expression editor)thanksnayana
sreenivasareddy.aug10
- Jul 10th, 2009
You could not write the subquery in Filter editor. Because Filter editor is for specifying the conditions only. You can write the? subqueries in by source qualifier. There you can use the filter condition as well as write the subquery and overide SQL you can archive.
Motilal
- Sep 12th, 2006
The subquery syntax is very similar to SQL.Still, you can see the navigator page in the left side of the editor page.we have ports,functions, etc there.you can double click on a fuction to find that funtion in your editor page.And the logic must be from you as obvious..
-
Routing Transformation
Hi, I am new to Informatica just trying to do some mappings. I tried to do SCD type 1. after loading source tables I used expression transformation to do some formatting and then I used Router Transformation. But when I tried to post all fields from expression to router they are by default becoming only input variables . I am unable to link these variables to an Update Strategy. What to do now???...
babushiv
- Jun 18th, 2009
All the Above answers are wright, just create port in group and name it as update if you want to update, by default a port is created, now just map into corresponding router trans from update transThanksBabu Shiv
sakthi.jaganathan
- Aug 25th, 2008
In Router transformation first you want create a group, how can you create?a group means, in expression transformation?you will?set a?flag values, you just click the group tab in router transforma...
-
What are the steps involved in to get source from OLTP system to staging area
ramsetty
- Jun 17th, 2009
Data profiling is a technique used to analyze the content, quality, and structure of source data. Use PowerCenter Data Profiling to detect patterns and exceptions of source data during mapping develop...
vizaik
- Mar 24th, 2007
go to source analyzerimport databasesgo to warehouse designerimport databases (target definitions) else create using generate sqlgo to mapping designerdrag and drop sources and targets definitionslink ports properlysave to repositorythan q
-
We are using Update Strategy Transformation in mapping how can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.
samirdesai999
- Jun 13th, 2009
Use following expression in update strategy transformation.iif ( condition 1 , DD_INSERT, condition 2 , DD_UPDATE, condition 3 , DD_DELETE, DD_REJECT -- for default)and set session property as data driven, You can cross check these conditions values during session debug runs.
prade
- Jun 26th, 2008
In general DWH scenario, we create TABLE_REJECT or FILE_REJECT to keep a check of the rejected records. For all the updates happening we keep timestamp or some other flag in the database.Before t...
-
What is tracing level and what are the types of tracing level?
Tracing level represents the amount of information that informatcia server writes in a log file. Types of tracing level Normal Verbose Verbose init Verbose data
Sumithav29
- Jun 12th, 2009
When you configure a transformation, you can set the amount of detail the Integration Service writes in the session log.The session log tracing levels are: 1. Normal: Integration Service logs initial...
Minnu
- Apr 16th, 2007
Its 1) Terse 2) Normal 3) Verbose Init 4) Verbose data
-
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 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.
Informatica Interview Questions
Read Best Answer
Ans