-
How to remove 2 starting rows from my source flat flie
Rajesh
- Jan 31st, 2014
From Import Flat File Wizard, Edit the setting - Start Import At Row value as 3, that would skip/remove the first and second record and start importing from the third record.
-
Sorter transformation
If i enable select distince property in sorter transformation, on what basis the sorter tranformation removes the duplicate data
-
How to load fact table ?
tannya
- Dec 15th, 2006
Fact tables always maintain the history records,and mostly consists of keys and measures,So after all teh dimension tables are populated,teh fact tables can be loaded.The load is always going to be a incremental load except for the first time which is a history load.
hanug
- Dec 11th, 2006
HI:There are two ways u have to load fact table. 1. First time load2. Incremental load or delta loadIn both cases, u have to aggregate, get the keys of the dimentional tables and load into Fact.In case of increments, u use date value to pickup only delta data while loading into fact.Hanu.
-
What are Target Options on the Servers?
Target Options for File Target type are FTP File, Loader and MQ.
There are no target options for ERP target type
Target Options for Relational are Insert, Update (as Update), Update (as Insert), Update (else Insert), Delete, and Truncate Table.svivekananda
- Jun 26th, 2010
Relationals db: UPDATE, INSERT, DELETE, TRUNCATEFlat file: Dir / filename
MANOJ KUMARPANIGRAHI
- Feb 21st, 2007
Target option for Flat file,relational file (update ,Insert)
-
What r the mapping paramaters and maping variables?
Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session. When u use the maping parameter ,U declare and use the parameter in a maping or maplet.Then define the value of parameter in a parameter file for the session. Unlike a mapping parameter,a maping variable represents a value that can change...
chandrarekha
- Sep 12th, 2007
Mapping parameter represents a constant value defined before mapping run.
Mapping reusability can be achieved by using mapping parameters.
Mapping variable represents a value that can be changed during the mapping run.
Mapping variable can be used in incremental loading process.sithusithu
- Jan 19th, 2006
You can use mapping parameters and variables in the SQL query, user-defined join, and source filter of a Source Qualifier transformation. You can also use the system variable $$$SessStartTime. The Inf...
-
Can u use the maping parameters or variables created in one maping into any other reusable transformation?
Yes.Because reusable tranformation is not contained with any maplet or maping.
Prasad
- May 22nd, 2007
Hi, you can use the mapping parameters or variables in a reusable transformation. And when you use the xformation in a mapping, during execution of the session it validates if the mapping parameter that is used in the xformation is defined with this mapping or not. If not, the session fails.
mahesh4346
- Feb 2nd, 2007
But when one cant use Mapping parameters and variables of one mapping in another Mapping then how can that be used in reusable transformation when Reusable transformations themselves can be used among...
-
What r the joiner caches?
When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the caches, the Joiner transformation reads records from the detail source and perform joins.
bneha15
- Apr 23rd, 2007
For version 7.x and above :When the PowerCenter Server processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The...
sithusithu
- Jan 19th, 2006
Specifies the directory used to cache master records and the index to these records. By default, the cached files are created in a directory specified by the server variable $PMCacheDir. If you overri...
-
What r the basic needs to join two sources in a source qualifier?
Two sources should have primary and Foreign key relation ships. Two sources should have matching data types.
-
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 ...
-
Can u generate reports in Informatcia?
Yes. By using Metadata reporter we can generate reports in informatica.
srinivas.j.abinitio
- Jul 1st, 2011
Yes.?with using informatica Reporting too is informatica Analyzer.Thanks&Regards,Srinivas.
-
What is DTM process?
After the loadmanger performs validations for session,it creates the DTM process.DTM is to create and manage the threads that carry out the session tasks.I creates the master thread.Master thread creates and manges all the other threads.
a.himakar
- Sep 7th, 2010
It is the main processing unit in Informatica for executing the session with corresponding mappings. It has 3 sub services as 1) Reader Thread : It uses source table and source connections to ex...
ASHOK1324
- Apr 21st, 2009
The DTM process creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
-
Can u start a session inside a batch idividually?
We can start our required session only in case of sequential batch.in case of concurrent batch we cant do like this.
Vani_AT
- Apr 1st, 2008
Yes, we can do this in any case. Sequential or concurrent doesn't matter.Ther is no absolute concurrent workflow. Every workflow starts with a "start" task and hence the workflow is a hybrid.
-
How can u stop a batch?
By using server manager or pmcmd.
VEMBURAJ.P
- May 28th, 2007
By using menu command or pmcmd.
-
What r the session parameters?
Session parameters r like maping parameters,represent values U might want to change between sessions such as database connections or source files. Server manager also allows U to create userdefined session parameters.Following r user defined session parameters. Database connections Source file names: use this parameter when u want to change the name or location of session source file between session...
Vani_AT
- Apr 1st, 2008
A small correction, it starts with single dollar symbol . double dollar symbol is used for mapping parameters.
Vani_AT
- Apr 1st, 2008
In addition to this we provide the lookup file name.The values for these variables are provided in the parameter file and the parameters start with a $$ (double dollar symbol). There is a predefined f...
-
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
-
How do you import 500file from tally software in informatica. ?
Hemachandra
- Sep 26th, 2011
With my knowledge BY using LIST FILE we can do
jayapraveen
- Oct 8th, 2010
with my knowledge Consider the 500 file as a flat file and import it considering it as a flat file by fixed length or fixed tab, delimiters OR we can do in this way also by exporting the 500 file as xml file and import in source analyzer by using import from xml file
-
-
What happens when the session stops half way while loading? How to join a flat file without matching keys in RDBMS?
Sreeya
- Feb 21st, 2008
For the 1st part, we can adopt the recovery options as given in the session property, using the recovery strategy.But using this in real time scenario has proved to take a toll on the performance.Anot...
Deepak Rajkumar
- Feb 18th, 2008
Not sure about session stops without loading. We can join flat files without matching coloumns by:1: use a Seq. Gen. and generate Pks and join using Joiner.
-
How do you recover a session or folder if you accidentally dropped them?
satoru
- Jun 10th, 2010
You disconnect from repository without saving or if you're using versioning you can look in the check_out option from all users and restore them, though if you delete the folder you can restore it by versioning.
hanug
- May 8th, 2007
u can find ur backup and restore from the backup. If u dont have backup,u lost everything. u cant get it back.Thats why, we should always take the backup of the objects that we create.Hanu.
-
How do you recover a session or folder if you accidentally dropped them?
priyank_divya
- Jul 9th, 2012
If we drop any sessions accidentally, it wont be deleted permanently until we do a check in. So if we want to recover the session, we can do a undo checkout on the session.
N SRIRAM K
- Jun 1st, 2007
If you dropped your session or folder we can get it back if it has proper backup.we can also get it back when you have same folders in other environment, I mean to say, generally, we will have th...
Informatica Interview Questions
Ans