-
1)What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA.2) What are the common problems developers face while ETL development
svivekananda
- Jul 9th, 2010
1. check in session log + monitor output if the run is successful2. open the target and check the data manually
Prasad
- Jul 14th, 2006
Hi,If you want to know the performance of a mapping at transformation level, then select the option in the session properties-> collect performance data. At the run time in the monitor you can see it ...
-
How do you identify existing rows of data in the target table using lookup transformation
Can identify existing rows of data using unconnected lookup transformation.
Read Best Answer
Editorial / Best Answer
Answered by: SK
- Aug 30th, 2007
There are two ways to lookup the target table to verify a row exists or not :
1. Use connect dynamic cache lookup and then check the values of NewLookuprow Output port to decide whether the incoming record already exists in the table / cache or not.
2. Use Unconnected lookup and call it from an expression trasformation and check the Lookup condition port value (Null/ Not Null) to decide whether the incoming record already exists in the table or not.doppalpaudi
- Jul 9th, 2010
Lookup Transformation is used to cheek weather the data is present in target or not.This transformation is of 2 types 1. Connected lookup transformation2. Unconnected lookup transformation.By using above both we can cheek the target for data .
svivekananda
- Jun 26th, 2010
We can use both connected and unconnected lookups to check the existing records in the target table.
-
-
Session Status
How can we know the session status without workflow monitor?
etluser
- Jul 12th, 2010
Check s_m_*.log files under SessLogs folder and wkf_*.log files under WorkflowLogs folder on the server.
-
How to define Informatica server?
svivekananda
- Jul 14th, 2010
Informatica server is used to store all the mappings and is used to run the workflow and sessions
deeprekha
- Jul 6th, 2006
Informatica server is the main server component in informatica product family..Which is resonsible for reads the data from various source system and tranforms the data according to business rule and loads the data into the target table
-
Target Override
What is a target override table ?
etluser
- Jul 13th, 2010
Target override is same as Target Update Override. To use this property, set the update override property under the properties tab of the Target instance.Detailed explanation is available by the Power Center help under the topic "Target Update Override".
-
What is difference between cbl (constaint based commit) and target based commit?When we use cbl?
roshan239
- Jul 19th, 2010
You have asked a wrong question coz there is no concept constraint based commit.. It is constraint based ordering and target load plan which is for user to differentiate where data is t...
chandumedum
- Jan 25th, 2008
CBL means constaraint based loading.the data was loaded into the the target table based on the Constraints.i.e if we want to load the EMP&DEPT data,first it loads the data of DEPT then EMP because...
-
Updating Target Table
How can we update the target table without using update strategy?
Baloo_nanduri
- Jul 25th, 2010
There is a update Override option in the Target properties, you can write a update override query similar to SQL override in lookup's for updateing Targets. This option is enabled only at the mapping level i.e; in the designer you have to write your update override query in designer itself.
-
In a sequential batch how can i stop/start the particular session?
Baloo_nanduri
- Jul 25th, 2010
Right click on the session in the monitor if its a sequential run and there appears a stop option in the drop down once you stop the session workflow will either gets suspended or failed according to ...
rsannu2k
- Jun 5th, 2007
Madhu, Here is the statement to start/stop a session....$PM_HOME/pmcmd starttask -s $PM_PMSERVER_PORT -uv USERNAME -pv PASSWORD -wait -f $Folder -w $Workflow $Task# ...
-
Can we update data into target without using update strategy transformation?
Baloo_nanduri
- Jul 25th, 2010
Yes, its possible using Update override option available for Targets in designer
Sumithav29
- Sep 3rd, 2009
We can update the target table, by using the update override in target definition. it will update based on non key columns.
-
What is Load Manager?
Read Best Answer
Editorial / Best Answer
Answered by: Deb
- Jun 8th, 2005
I am providing the answer which I have taken it from Informatica 7.1.1 manual,
Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and carry out workflow tasks.When the PowerCenter Server runs a workflow, the Load Manager performs the following tasks:
1. Locks the workflow and reads workflow properties.
2. Reads the parameter file and expands workflow variables.
3. Creates the workflow log file.
4. Runs workflow tasks.
5. Distributes sessions to worker servers.
6. Starts the DTM to run sessions.
7. Runs sessions from master servers.
8. Sends post-session email if the DTM terminates abnormally.
When the PowerCenter Server runs a session, the DTM performs the following tasks:
1. Fetches session and mapping metadata from the repository.
2. Creates and expands session variables.
3. Creates the session log file.
4. Validates session code pages if data code page validation is enabled. Checks query
conversions if data code page validation is disabled.
5. Verifies connection object permissions.
6. Runs pre-session shell commands.
7. Runs pre-session stored procedures and SQL.
8. Creates and runs mapping, reader, writer, and transformation threads to extract,transform, and load data.
9. Runs post-session stored procedures and SQL.
10. Runs post-session shell commands.
11. Sends post-session email.raju4dw
- Aug 6th, 2010
Load Manager is responsible for dispatching the sessions and maintains Q of sessions based on first in and first out. Load Manager is also known as Master Processor (DTM) Data Transformation Manager.D...
Deb
- Jun 8th, 2005
I am providing the answer which I have taken it from Informatica 7.1.1 manual, Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation...
-
Main data object in between Source and Target
What is the main data object present in between Source and Target.
N SRIRAM K
- Apr 14th, 2008
Stage..where we can transform the source data and will load into TGT.Thx SRIRAM N
-
How do you maintain Historical data and how to retrieve the historical data?
kvrp461
- Aug 13th, 2010
In SCD Type2 we want to maintain the historical as well as current data.By using surrogate key or sequence generated key to maintain this historical data on to the target tables.
Thananjayan
- Nov 17th, 2007
You can maintain the historical data by desing the mapping using Slowly changing dimensions types.If you need to insert new and update old data,best go for Update strategy.If you need to maintain the ...
-
What r the connected or unconnected transforamations?
An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.
kvrp461
- Aug 18th, 2010
Connected: The transformation is?participated in the flow of data from source to target.Unconnected: The transformation is not?participated in the flow of data from source to target.
chandrarekha
- Sep 12th, 2007
Connect Transformation :A transformation which participates in the mapping data flow Connected transformation can receive multiple inputs and provides multiple outputsUnconnected : A unconnected...
-
What r the unsupported repository objects for a mapplet?
COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look Up functions XML source definitions IBM MQ source defintions
kvrp461
- Aug 18th, 2010
1)Stored procedure preload or postload is not possible.2)Dont allow the not reusable sequence generator.3)xml source qualifier4)Normalizer5)Nested mapplets
job_infa
- Jan 28th, 2009
−Normalizer transformations−Cobol sources−XML Source Qualifier transformations−XML sources−Target definitions−Pre- and post- session stored procedures−Other mapplets-PowerMart 3.5-style LOOKUP functions-non reusable sequence generator
-
What is the default source option for update stratgey transformation?
Data driven.
Gyaneshwar
- Mar 28th, 2006
DATA DRIVEN
-
At what frequent u load the data?
pradeeshkumar
- Aug 19th, 2010
The frequency of loading data is based on the needs. It may be once in a week or at every nights.
opbang
- Oct 4th, 2006
Loading frequency depends on the requirement of Business Users, It could be daily during mid night... or weekly... Depending on the frequency... ETL process should take care... how t...
-
Which transformation has the most complexity Lookup or Joiner?
pradeeshkumar
- Aug 19th, 2010
Its not that complexity associated with the transformation. Its just how far you know to use which transformation is suitable for solving a problem.
sai
- Feb 14th, 2007
Lookupbut it will reduse the complexity of the solutions and improves the performance of the workflows.
-
In workflow can we send multiple email ?
WMC
- Oct 9th, 2006
Yes, only on the UNIX version of Workflow and not Windows based version.
-
1) How to load the data (like refresh load, quarterly load, hourly load etc)2) what is lookup ? (Lookup is a join is it wright or wrong)ub
pradeeshkumar
- Aug 19th, 2010
Lookup is not a join. Lookup is?more?similar to the real world example,?you?are conducting a interview and you?have?the list of registered candidates in hand.?In oreder to see whether a candidate is registered or not, you'll look into the list and then verify. That's it.
Informatica Interview Questions
Read Best Answer
Ans