-
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....
-
DTM Buffer Size Default Buffer Blocksize
What is DTM buffer size, Default buffer blocksize. If any performance issue happens to session, which one we have to increase and which one we have decrease.
gaurav2485
- Jan 8th, 2009
DTM buffer size is memory you allocate?to DTM process (12 MB)Buffer Block size is Size of heaviest Source/Target* number of rows that can be moved at a time(should be minimum 20 (64 KB)And Informatica...
calltomadhu
- Dec 31st, 2008
Hey,workflow manage allocate default of 12MB size to session. you can increase this according to you requirement by specifying them in the form of bytes or you can set to AUTO it will take accordingly...
-
Find Special Character in Flat File
How to find whether special character is present in flat file's data using Informatica as a ETL tool
janardhanpala
- Jun 14th, 2010
If you want find special symbol in flat file when you are importing from file at that time you can set delimeter -check the option- other and you can type symbol which is in your flat file.
nandagiripradeep
- Jan 25th, 2009
There would be a code page present in the properties of the source definition in case of a flat file. Such as LATIN, WESTERN EUROPEAN. We need to choose proper page code to identify the special characters in flat file.
-
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.
-
Informatica Production Support Member
What is the responsibility of a Informatica production support member?
Senthilkrishnan
- Nov 16th, 2009
1) Have to monitor the scheduled jobs or run the workflows and scripts which needs to run the day.2) If any issues or job fails, Immediately check the logs and contact with support team if needed. Fre...
DK_Reddy
- Apr 26th, 2009
Production support means, whenever a problem/Error rises while the product is running we have to identify that problem/Error and solve it, or intimate about that problem/Error to the concern perso...
-
Target Data Loading
How & Where will you can see data loading in targets dynamically?
sharmahariom
- Jan 18th, 2010
You can use Power Center Monitor. Once you will open property window in monitor you can see dynamic data loading there.
vens28
- Apr 28th, 2009
We can check the target recorded loaded dynamically? by validating the query on target records with time period.1) We need to run the target records related query for? first load with time period an...
-
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)
-
Retrieve only Distinct Record from 'flatfile' Source
How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it posible? How?
sheeladere
- Jan 5th, 2010
We can use Aggregate transformation for this. Group by on all the columns in the Aggregator and get only first or last record from the group, it will give you distinct records.But sorter is the best option, I am not sure why you want to avoid it, is there any specific reason?
jsrprasad0402
- Sep 22nd, 2009
Create a Variable port for all the input port and keep them in a seequence that the variable ports will access first after the input port. Then, compare the same variable ports in the ouput port along...
-
Transaction Control
Explain Why it is bad practice to place a Transaction Control transformation upstream from a SQL transformation?
nitijosh
- Nov 22nd, 2009
First Thing as mentioned in the Other Posts it drops all the incoming transaction control boundries.Besides you can use Commit and Rollback statements within SQL Transformation Script to control the transactions, thus avoiding the need for the Transaction Control Transformation.
-
Session Performance
How would you improve session performance?
satoru
- Jun 17th, 2010
the first thing before touching the cache of the session is doing a tuning and optimize your mapping. The tuning is in the session in the mapping tab. It allows you to see which transformation is the ...
rajeev_bitspilani
- Dec 28th, 2009
Session performance can be improved by allocating the cache memory in a way that it can execute all the transformation within that cache size.Mainly only those transformations are considered as a bott...
-
Power Exchange
What is Power Exchange?
latha.c
- Apr 19th, 2010
Power Exchange deals with the mainframes. CDC (Change Data Capture) source concept also there means?insteed of using delta process logic with different transformations?in the Informatica?PowerCenter, we can create CDC sources in power exchange and import that into power center.ThanksLatha
hundwanipankaj
- Apr 5th, 2010
Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by avoiding manual coding of data extraction programs
-
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...
-
Which transformation can perform the non equi join?
KRISHNAREDDY
- Jan 27th, 2012
BY USING LOOKUP T/R WE CAN JOIN NON EQUI JOINS
latha.c
- Apr 20th, 2010
Non Equi Join is same as outer join in join transformation. So we can do by using the joiner in Informatica.
-
What is redo log file in Informatica?
jayapraveen
- Oct 4th, 2010
Redo log file keeps the value when the "commit"command executes and replaces the value with new value.
satoru
- Jun 30th, 2010
In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Before a user receives a "Commit complete" message,...
-
Informatica and SAS Exit
-
Event Wait
What is the use of event wait?
sugato.sam
- Sep 22nd, 2010
Event wait is a task created in Informatica to look out for events such as waiting for a file in?the specified directory of the server. Once this task is completed, another workflow dependent on this task will get started.
nagadurgaraju
- Aug 27th, 2010
Event wait is used for loading data proper way, removing deadlock while using schemas.
-
Pipeline Partitioning
Explain the pipeline partitioning with real time example.
sumit dabas
- Aug 3rd, 2011
Pipeline partitioning consist of a long pipe cut(partitioned from between),there r many kinds of pipe..............
prashant.baranwal
- Sep 5th, 2010
Pipline partitioning in Informatica is similar as we have threading concept in Operating System. Here we divide data reading, writing and data transformation in more than one thread such that system c...
-
Informatica Integration Service
How many Integration Service does Informatica Server contain? only one or many? Explain
-
-
Fact table size calculation
How to calculate fact table size.........and how to find fact granularity? Please tell me answers to these 2 questions..
n.sriramk
- Nov 5th, 2010
Size= Number of expected records * E (sum of all columns data type size) bytes
divakar021
- Oct 7th, 2010
A Fact table is calculated based on "lowest level granualarity". The lowest level granualarity can be determined from the ...
Informatica Interview Questions
Ans