-
Explain pmcmd?
sridhar39
- Dec 29th, 2007
hi PMCMD means program command line utility. it is a program command line utility to communicate with informatica server. &...
chandrarekha
- Sep 28th, 2007
It a command line program. It performs the following tasksStart and stop the session and batchesStop the Informatica ServerChecks whether the server is working or not
-
Explain Session Recovery Process?
sridhar39
- Dec 29th, 2007
hi, when the informatica server starts a recovery session it reads the opb_srvr_recovery table and notes the r...
chandrarekha
- Sep 28th, 2007
You have 3 steps in session recoveryIf Informatica server performs? no commit, run the session againAt least one commit, perform recoveryperform recovery is not possible, truncate the target table and run the session again.Rekha
-
In which particular situation we use unconnected lookup transformation?
sridhar39
- Dec 28th, 2007
hi, both unconnected and connected will provide single output. if it is the case that we can use either unconnected or connected i prefer unconnected why because uncon...
Tarun Vig
- Oct 12th, 2007
Use of connected and unconnected Lookup ic completely based on the logic which we need.However i just wanted to clear that we can get multiple rows data from an Unconnected lookup also.Just concatinat...
-
Informatica Working with flat files
How can we display delimiters beside column names of target flat file?
komalahanumantharao
- Dec 26th, 2007
While creating the targets using flat files we will get a options to specify whether the flat file is delimited of fixed length following tht steps in one of the steps we get how to notify the delimiters in the flat file there we can adjust delimiters beside the target columns name
-
How many repositories can we create in Informatica?What is aggregate awareness?What are parallel queries and query hints
hemachandra
- Dec 26th, 2007
Query hints are used in RDBS concept, when you write SQLs in pervious days developer use give hint points while writing the query for DB engine, they are called rule based DB, now the rule based DB is fading out in the market, these days youwill find all new DBs as cost based
hemachandra
- Dec 26th, 2007
Aggregate awareness is the method in Business Objects while creating measures in the universe, it is process where you define the aggregation strategy which you wanted BO to follow, useful mostly for Drill downs based on different dimentions
-
How can we delete duplicate rows from your source in mapping without using SELECT DISTINCT option in source qualifier?
hemachandra
- Dec 26th, 2007
Also you can use group by on all columns you are pulling either by sql override or aggrigator
-
How can we know whether data is changed from last time to this time?How can we identify the whether data is changed or not.
komalahanumantharao
- Dec 26th, 2007
By using the typeII mapping i.e. we use a seperate flag key which keeps changing when we changet the date in the table
-
How can we append the data coming from multiple sources which dont have any relations into the flat file target which already exists and has data.
komalahanumantharao
- Dec 26th, 2007
First we should generate theWarehouse key using sequence generator and insert the rows into the target using update strategy
-
What is the difference between ODBC , DSN , NATIVE and TCP/IP Connections?
komalahanumantharao
- Dec 26th, 2007
ODBC is the database drivers which is used to connect from clinet to the relational database.DSN is the data service name which is thename of the odbc name give by the customer inoreder to...
-
Informatica power center 7.1.1 Installation on Windows vista home
Hi,Can Informatica power center 7.1.1 installed on Windows vista home premium? If so how to install informatica server and repository server?Thank you,Vamshi.
anithashriya
- Dec 22nd, 2007
But i could not find an option windows xp service pack 2 after right clicking on setup.exe of informatica powercenter 7.1.1, still the error is continuing if i try to execute setup.exe ...can anyone come up with the solution
Pallavi50953
- Dec 21st, 2007
Hi, I installed informatica powercenter 7.1 in my laptop and i can even open repository server console. But now for connecting to the repository it is asking for a password.Can any one specify which port and password should i specify for connecting to the repository.
-
How can you join two tables without using joiner and sql override transformations?
senthilkar
- Dec 17th, 2007
If the sources are homogenous, we use source qualifierif the sources have same structure we can use union transformation
chandrarekha
- Sep 24th, 2007
You can join two tables with in the same database by using lookup query override
-
Informatica : set statement in update
Need to update the existing records,The record which is coming for update should be inserted and also the previous record's one column must be modified. i have used look up to look up the data.used router to separate the data for insertion and update.Used expression to calculate something on those new records for update.service_code valid_startdate valid_enddate01 2003-03-03...
anu_v_iitd
- Dec 13th, 2007
Actually what need to be done here is:You need to use two update strategy transformation just before inserting or updating the data into target table, Obviously there will be two instances of target t...
-
Repository has been shutdown error
[09/23/2007 11:34:53] (Alert) Repository gowtham has been shutdown. I am getting error like this in services informatica repository server is starting but informatica is not starting pls help in this thanks and regards gowtham
prasad1507
- Dec 11th, 2007
Please check whether u have correct user privilege in windows to start services. You should have service start privilege in windows. One more thing Informatica server will be started and alive only any workflow is created.If this doesnt help, come back with exact details of your problem
vemurisasidhar
- Sep 26th, 2007
i think u need to restart tje services again. before that check all the configurations. like repserver,server,repository admin management console.
-
What are tracing levels in transformation?
prabhat007
- Dec 8th, 2007
Tracing level in the case of informatica specifies the level of detail of information that can be recorded in the session log file while executing the workflow.4 types of tracing levels supported1.Nor...
Abhishek Shukla
- Nov 19th, 2007
Tracing level keeps the information aboaut your mapping and transformation.there are 4 kind of tracing level which is responsible for giving more information on basis of their characterictis.ThanksAbhishek Shukla
-
Informatica union transformation
What is the practical use of a union transformation?
ask_kaushik
- Dec 6th, 2007
That was the description....practical use would be like : if you have 3 different sources which returns different number of records but with the same ports and datatypes, union transformation can be used to sum up these records and proceed to the next transformation as the same pipeline.
ask_kaushik
- Dec 6th, 2007
The Union transformation is a multiple input group transformation that you use to merge data from multiple pipelines or pipeline branches into one pipeline branch. It merges data from multiple sources...
-
How many types of TASKS we have in Workflomanager? What r they?
Siddhant Mirji
- Jul 11th, 2007
SessionCommandDecisionEvent WaitEvent raiseEmailTimerAssignmentControlWorklet
-
What is the best way to modify a mapping if the target table name is changed?
ajmani
- Dec 6th, 2007
incase if only the target table name has changed ,then simply go to target designer, right click on target table name ->edit->rename it and say apply,u might not need to change in mapping design...
-
How to delete data from target table before insert starts without using truncate option in MappingThanks,
ajmani
- Dec 5th, 2007
This can be done by a pre sql script in the session.simply go to session->mappings->target.there in presql script give truncate table tablename.
-
Repository deletion
what happens when a repository is deleted?If it is deleted for some time and if we want to delete it permanently?where is stored (address of the file)
sandeep_sajjan
- Dec 3rd, 2007
repository is stored in database ,go in repository admin console right click on repository then choose delete . a dialog box is displayed fill up the user name(database user wr ur repository is ...
chandrarekha
- Nov 29th, 2007
I too want to know the answer for this questionI tried to delete the repository ,that time it was deleted after that i tried to create the repository with the same name what i was deleted earliar , it...
-
What will be the output?Select 'a' from table1 UNION select 1 from table2;
gdngajudn
- Nov 29th, 2007
Execution of this query will give an error.We will get error in this Case as the the out put for table 1 is a string where as the the return of table 2 is a number and both are of different datatype.
Informatica Interview Questions
Ans