-
Informatica Tracking Levels
What are the Tracking levels in Informatica transformations? Which one is efficient and which one faster, and which one is best in Informatica Power Center 8.1/8.5?
SAURABH2301
- Oct 24th, 2009
Also for efficient & faster depends on your requirement.If you want minimum information to be written to the session logs you can use the Terse tracing level.From Informatica Transformation G...
SAURABH2301
- Oct 24th, 2009
I guess you are asking about the tracing level.? When you configure a transformation, you can set the amount of detail the Integration Service writes in the session log.? PowerCenter 8.x support...
-
What is Transaction?
karttik
- Oct 23rd, 2009
Functionally we can say day to day business activities is a transaction. Transaction is a unit of work. Technically we can say Physical change in database after submitting a commit or rollback statement.
irfan
- Sep 8th, 2006
Hi, Transaction is any event that indicates some action. In DB terms any commited changes occured in the database is said to be transaction.
-
What is the size of data mart?
chillkrishna
- Oct 11th, 2009
Size of the datamart completely based on your client requirements. BA's & DBA's basically decide datamart size.Hope this helps.Krishna M
Thananjayan
- Dec 6th, 2007
Hi,Data mart is a part of the data warehouse.for example In an organization we can manage Employee personal information as one data mart and Project information as one data mart,one data ware house ma...
-
Dependency Problems
What are the possible dependency problems while running session?
ashrita
- Oct 8th, 2009
Dependency problems means when we run a process, the process output is input to other process. Then first process is stopped then it causes problem or stop running?other process. One process is depen...
gazulas
- Apr 22nd, 2009
Hey, quation is not clear, any how,,Dependency for workflow will always be (sessions and mappings)session will always be (mappings) mappings will always be (transformations)
-
Sequence Generator
Why sequence generator is not directly connected to joiner transformation?
manoj_pathak
- Sep 30th, 2009
Remember Joiner tx can accept input from only 2 pipelines.Now only following 2 scenerios possible to have both joiner and Seq Gen tx:1)2 input pipelines are already connected and then we want to conne...
itisanimesh
- Aug 6th, 2009
In Addition to previous answerSequence Generator transformation is a Passive and Connected transformation. It is used to create unique primary key values or cycle through a sequential range of numbers...
-
still the same problem :(">
Im trying to fill a primary key field of a target using a trigger on the table to insert a sequence number for each insertion of a new row.After running the session im finding that the key column is populated ,but,not in an order. the key field starts with some 75 goes till 200,the again 551 comes and goes till 10500 ,suddenly the next key field is filled with 21 and goes till 72.... is there any reason why this is happening in this reason.FYI : i truncated the table data ,then dropped the seq. and the trigger and created them freshly ,specifying the start value in seq. as "1"still the same problem :(
ashis.mohapatra
- Sep 16th, 2009
It depends what database you are using. If you are using Oracle or SQL server it should not be the case. But if your database is Teradata or Netezza then that will happen. Because Teradata and Netezza uses multiple parallel processing units.ThanksAshis
rajani
- Oct 10th, 2006
Use sequence transformer to resolve this problem. In transformer properties you need to set start and end value and other properties...
-
-
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...
Informatica Interview Questions
Read Best Answer
Ans