-
Explain about scheduling real time in informatica
sanghala
- Mar 1st, 2007
Scheduling of Informatica jobs can be done by the following ways:Informatica Workflow MangerUsing Cron in UnixUsing Opcon sheduler
-
Informatica Bulk Load Question
If flat files is your source. what are the option in session to take bulk of files from same folder have the same structure of all the files..
parambollina
- Mar 27th, 2007
For that you can select source file type as indirect and you have to specify that folder path at source file directory.
-
What is the difference between mapplet and reusable Transformation?
veera_kk
- Mar 30th, 2007
A set of reusable transformations is called mapplet where as a single reusable transformtion is called reusable transformation.
-
Explain about Incremental Extraction in Informatica
venkatasuryadwh
- Dec 16th, 2008
Use sql overide to capture the change data capture which looks like this..... ( EFF_FROM_DATE >= $$LAST_RUN_DATE AND EFF_FROM_DATE < TO_DATE('$$$SessStartTime'...
-
How to import flatfiles from remote location.
venkatasuryadwh
- Dec 16th, 2008
You can do this with the help of?FTP s/w's like Cute FTP s/w from your local desktop to the unix box viceversa.I think this will solve your problem.RegardsVenkat
-
How to assign a work flow to multiple servers?
I have multiple servers, I want to assign a work flow to multiple servers
-
Where do you set target load plan
prasunnesu
- Dec 1st, 2008
The target load plan is required when you have more than one target and you want to set the priorities for the load. Steps to use this. Open the mapping> click on Mapping Tab> target load plan&g...
-
How to extract data from XML and flatfiles in informatica?
k.shankar
- Apr 7th, 2011
When importing the source definition, the file must be in a directory local to the client machine. In addition, the Integration Service must be able to access all source files during the session. ...
-
-
Informatica transformation
What is the diffference between SQL override and SQL transformation ?
-
-
What is the difference between connected and unconnected stored procedures.
sithusithu
- Jan 24th, 2006
Run a stored procedure before or after your session.Unconnected Run a stored procedure once during your mapping, such as pre- or post-session.Unconnected Run a stored procedure every time a ...
sangeetha
- Sep 26th, 2005
Unconnected:The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another t...
-
In a filter expression we want to compare one date field with a db2 system field CURRENT DATE.Our Syntax: datefield = CURRENT DATE (we didn't define it by ports, its a system field ), but this is not valid (PMParser: Missing Operator)..Can someone help us. Thanks
gazulas
- Jan 29th, 2006
The db2 date formate is "yyyymmdd" where as sysdate in oracle will give "dd-mm-yy" so conversion of db2 date formate to local database date formate is compulsary. other wise u will get that type of error
Sitaram Yarlagadda
- Nov 23rd, 2005
Use Sysdate or use to_date for the current date
-
How do you decide whether you need ti do aggregations at database level or at Informatica level?
prasadns26
- Jul 18th, 2006
hi,see informatica is basically a integration tool.it all depends on the source u have and ur requirment.if u have a EMS Q, or flat file or any source other than RDBMS, u need info to do any kind of a...
Rishi
- Dec 5th, 2005
It depends upon our requirment only.If you have good processing database you can create aggregation table or view at database level else its better to use informatica. Here i'm explaing why we need to...
-
Can Informatica be used as a Cleansing Tool? If Yes, give example of transformations that can implement a data cleansing routine.
prasadns26
- Jul 18th, 2006
hi,what ever said by rishi is correct,info can be used as a cleansing tool.usually EXP is used for cleaning data using data cleansing functions and other functions present in infa.eg,assign default va...
Rishi
- Dec 5th, 2005
Yes, we can use Informatica for cleansing data. some time we use stages to cleansing the data. It depends upon performance again else we can use expression to cleasing data.For example an feild X...
-
What is the use of incremental aggregation? Explain me in brief with an example.
srinivas vadlakonda
- Sep 28th, 2006
Incremental aggregation is in session properties i have 500 records in my source and again i got 300 records if u r not using incremental aggregation what are calculation r using on 500 records again ...
gazulas
- Jan 29th, 2006
its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.
-
How to use mapping parameters and what is their use
madhu sudhan rao
- Feb 18th, 2006
mapping parameters and variables make the use of mappings more flexible.and also it avoids creating of multiple mappings. it helps in adding incremental data.mapping parameters and variables has to cr...
gazulas
- Jan 29th, 2006
in designer u will find the mapping parameters and variables options.u can assign a value to them in designer. comming to there uses suppose u r doing incremental extractions daily. suppose ur source ...
-
In a sequential Batch how can we stop single session?
prasadns26
- Jul 18th, 2006
hi,we can stop it using PMCMD command or in the monitor right click on that perticular session and select stop.this will stop the current session and the sessions next to it.
vasulu
- Feb 17th, 2006
we have a task called wait event using that we can stop.we start using raise event.this is as per my knowledge.
-
What is IQD file?
sathyanath.gopi
- Feb 27th, 2006
IQD file is nothing but Impromptu Query Definition.This file used for creating cubes in COGNOS Powerplay Transformer.
sathyanath.gopi
- Feb 27th, 2006
IQD file is nothing but Impromptu Query Definetion,This file is maily used in Cognos Impromptu tool after creating a imr( report) we save the imr as IQD file which is used while creating a cube in power play transformer.In data source type we select Impromptu Query Definetion.
-
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Shanmugam
- Jul 6th, 2006
The only two possibilities as of I know isBoth the table should have primary key/foreign key relation shipBoth the table should be available in the same schema or same database
geek_78
- Feb 18th, 2006
We can connect two relational table in one sq Transformation.No errors will be performRegards,R.Karthikeyan
Informatica Interview Questions
Ans