-
Can we revert back reusable transformation to normal transformation?
venkat2ram
- Jul 14th, 2014
Yes, We can!
Open the folder where the reusable transformation is existing.
Then open mapping designer then drag the reusable transformation to mapping designer area. Now hold the Ctrl key and drop it.
Now you have non reusable version of your reusable transformation.
ThanksBibhu
- Jul 4th, 2014
Yes, we can. It can be done in the transformation developer.
-
What is the way to add the total number of records that have been read from SRC in the TGT file as last line?
What is the way to add the total number of records that have been read from SRC in the TGT file as last line? Let me clear you if my TGT is a flat file and want to add total number of records that are written in TGT as a last line with sysdate.
-
Difference between stop & abort
What is the difference between STOP and ABORT options in Workflow Monitor?
-
Informatica number formatting
How to format phone number 9999999999 into (999)999-9999 in informatica
-
-
Hw to work with pmcmd on windows platform
Joe
- Feb 7th, 2013
ECHO OFF This automates the informatica workflow run using pmcmd ECHO c:informaticaserverinpmcmd startworkflow -u username -p password -s server:host -f Folder -wait MYWORKFLOW
dl_mstr
- Feb 11th, 2008
C:-->Program Files-->Informatica PowerCenter 7.1.3-->Server-->bin-->pmcmd.exe
-
How to explain sales project in interview.
How to explain sales project in interview.could u tell me modules or dim table with some column names and facts how to move data from dim to facts.and give me what logic u implement in that projects
Lokesh M
- Jan 3rd, 2013
For explaining your sales project: You can follow these points and cover them based on your actual project. 1. Name of the Project 2. Name of the Client 3. Brief Description of the Client 4. Brief ...
-
Informatica
I have 2 sources one is relational table with 7 ports
second is flat file with 8 ports.How can I get the combined output and I should not do any modifications to the source structure?priyank_divya
- Aug 3rd, 2012
Hi, I think we can obtain the results by using Joiner transformation. If the sources have no common columns, we can add one extra column with a value 1 in both the sources and then can join based on ...
-
How can I use multiple filter transformations? How do I pass dropped rows to next filter transformation to check the conditions?
Rajarao marisa
- May 31st, 2012
Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...
srinuraj
- May 31st, 2010
You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...
-
Explain the informatica Architecture in detail
Read Best Answer
Editorial / Best Answer
Rajsuni- Member Since Apr-2011 | Apr 1st, 2011
Informatica Architecture :
client tools-
Repositoy Manager-> Pc Designer-> WFManager-> WFMonitor
| | | |
(creat,mdify,del-folders, (src&Tar def, (create tasks (display
privilages& access RS) mapings,maPlets)connect to work flow) reult/output)
---------------------
Powercenter tools--
PC service <--------------------->Repository Database
|
|
<-------> PC Server<---->
here: Pc-PowerCenter.
venkat m
- Sep 20th, 2011
Informatica Architecture : client tools- Repositoy Manager-> Pc Designer-> WFManager-> WFMonitor | ...
ram_infa
- Sep 15th, 2011
When we install the informatica powercenter, the following components gets ionstalled 1) powercenter clients 2) Integration service 3) powercenter Repository service 4) powercenter Repository 5) power...
-
What are 2 modes of data movement in Informatica Server?
The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)b) ASCII - IS...
Read Best Answer
Editorial / Best Answer
Answered by: purushotham
- Aug 9th, 2005
the two types of modes are:
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.amolrenose
- Sep 18th, 2011
Data Movement Modes
1. ASCII mode :- Single byte of data is processed.
2. UNICODE mode :- Two bytes of data is processed.
Data Loading Modes
1. Normal Mode :- Commit is executed after 10000 records (default).
2. Bulk Mode :- Commit is executed after all records have been loaded. -
Discuss which is better among incremental load, Normal Load and Bulk load
Read Best Answer
Editorial / Best Answer
gazulas- Member Since Jan-2006 | Jan 29th, 2006
if supported by the database bulk load can do the loading faster than normal load.(incremental load concept is differnt dont merge with bulk load, mormal load)
ram_infa
- Sep 14th, 2011
It's totally depends upon the requirement. generally bulk load is faster caz it won't write the data to database logs so we can't do session recovery where as in normal load it is very slow comparing to bulk but the advantage is we can do session recovery..
vikota
- Apr 12th, 2011
Incremental load: Incremental means suppose today we processed 100 records ,for tomorrow run u need to extract whatever the records inserted newly and updated after ...
-
What is Session and Batches?
Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches...
Read Best Answer
Editorial / Best Answer
sanghala- Member Since Apr-2006 | May 14th, 2007
Session: A session is a set of commands that describes the server to move data to the target.
Batch : A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc..,)
There are two types of batches in Informatica:1. Sequential: When Data moves one after another from source to target it is sequential
2. Concurrent: When whole data moves simultaneously from source to target it is Concurrent
ram_infa
- Sep 9th, 2011
Session is nothing, but it tells the integration service, when and how to move the data from sources to target
Group of sessions is called a batch..ravindra
- Jul 15th, 2011
Session is an object of repository,which instructs the informatica server(integration service)to execute the mapping with given database connection's...
-
Convert Source Column into Target Rows
What transformation do you use to convert source column into target rows? Explain
vijayant.sanjay
- Sep 7th, 2011
Normalizer is basically used to convert rows to columns. I don't think alone normalizer is sufficient to convert columns into rows. In certain scenario you use this sequence of t/f to convert columns ...
Ishaan_Kulshrestha
- Apr 14th, 2010
Hi Sahan,Please let me know how aggregator is used here. I think Aggregator is required when we denormalise data and here our requirement is to Normailse the data.Please correct me if I am wrong. Thanks
-
$ & $$ in Mapping or Parameter File
What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?
Read Best Answer
Editorial / Best Answer
anshu.gangwar- Member Since Sep-2008 | Sep 30th, 2008
$ prefixes are used to denote session Parameter and variables and $$ prefixes are used to denote mapping parameters and variables
SEHAJ
- Aug 18th, 2011
$-This is d symbol for server o inbuilt variable.
$$-this is the symbol for the variables o parameters which v create
sweetmann27
- Aug 10th, 2011
Hi,
$ is session parameter e.g $DBConnection
$$ is mapping parameter/variable e.g $$LASTRunDate
Thanks -
What is Join index
Hi everyone ,Can u explain in detail what is a join index,with example.And what is its importance in teradata.
Read Best Answer
Editorial / Best Answer
rin23- Member Since May-2011 | May 12th, 2011
A join Index is a cross between a view and an index. It is like a view in that it is created using a query to specify the structure, composition and source of the contents. It is like an index in the way that it is used automatically by the database system to improve the performance of a query. Join indexes use the "classic" space-time trade off trading disk space for storage of the join index to get improved performance for queries. Unlike many other materialized view implementations, Teradata join indexes are updated immediately and automatically when changes are made to the base tables. There is never a concern that you might be using stale data when the system chooses to use a join index in the query plan. Also, Teradata uses its sophisticated coverage testing algorithm to minimize the cost associated with join index maintenance.?
rin23
- May 12th, 2011
A join Index is a cross between a view and an index. It is like a view in that it is created using a query to specify the structure, composition and source of the contents. It is like an index in the ...
-
What is the difference between Narmal load and Bulk load?
hanimi
- Apr 28th, 2011
Bulk load the dwh server bypass the data to the target, in that we have session performance improves.in normal load data moves the database log file.
Ray
- Mar 22nd, 2006
Also remember that not all databases support bulk loading. and bulk loading fails a session if your mapping has primary keys
-
Which transformation you need while using the COBOL sources as source definitions?
Read Best Answer
Editorial / Best Answer
sithusithu- Member Since Dec-2005 | Jan 20th, 2006
Normalizer transformation.
Normalizer transformation which is used to normalize the data.Since COBOL sources are often consists of De-normalized data.sithusithu
- Jan 20th, 2006
Normalizer transformation. Normalizer transformation which is used to normalize the data.Since COBOL sources are often consists of De-normalized data.
-
Which source definition files are needed to provide support for Mainframes ?
Read Best Answer
Editorial / Best Answer
deepthi_97- Member Since Sep-2009 | Sep 23rd, 2009
Cobol files and we use normalizer transformation
Prabu
- Jun 22nd, 2007
The mainframe files are Used as VSAM files in Informatica by using the Normaliser transformation
-
What are various types of Aggregation?
Various types of aggregation are SUM, AVG, COUNT, MAX, MIN, FIRST, LAST, MEDIAN, PERCENTILE, STDDEV, and VARIANCE.
Read Best Answer
sithusithu
- Jan 19th, 2006
AVG COUNT FIRST LAST MAX MEDIAN MIN PERCENTILE STDDEV SUM VARIANCECheers,Sithu
Informatica Interview Questions
Read Best Answer
Ans