-
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...
-
Why we use stored procedure transformation?
For populating and maintaining data bases.
bneha15
- Apr 18th, 2007
We use a stored procedure transformation to execute a stored procedure which in turn might do the above things in a database and more.
-
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
-
Hi everyone,can anyone explain error handling in informatica with examples so that it will be easy to explain the same in the interview.
Rajan Raorane
- Oct 21st, 2010
Scenario in which when a load of 1000 records is loaded into the target and 100 records are bad records, those hundred goes to badfile dir which mention Session and the rest of the 900 should load to ...
sreenivasareddy.aug10
- Jul 10th, 2009
Error HandlingSometimes a stored procedure returns a database error, such as “divide by zero” or “no more rows”. The final result of a database error during a stored procedure ...
-
Informatica Live Interview Questions
here are some of the interview questions i could not answer, any body can help giving answers for others also. thanks in advance.Explain grouped cross tab?Explain reference cursorWhat are parallel query's and query hintsWhat is meta data and system catalogWhat is factless fact schemaWhat is confirmed dimensionWhich kind of index is preferred in DWHWhy do we use DSS database for OLAP tools
-
How to load to the target which already contains data
Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.
Jaspreet_banga
- Jun 8th, 2011
First of all alter the old target table in oracle and create another new table using query as CREATE TABLE new_table AS SELECT * FROM old_table, now import this table into the ta...
padamalacharan
- Aug 25th, 2010
If the target is flatfile 'check' the option at session level:"append if exists"
-
Informatica error while creating system DSN
Hi,Can you please tell me whether Informatica 7.1.1 powercenter version can be installed on windows XP professional. Iam trying to install both client and server on the same machine.But when Iam trying to create a system DSN from Source Analyzer menu, the application gets terminated it self.Please advise me if it should work.Thanks,
mr.kishorev
- Feb 9th, 2010
Yes, you can install the power center 7.1.1 in windows XP,1. Create a new user account in Oracle. and give grant and commint previliges to that account.2. Configure informatica server by giving the de...
kolli.siva
- Dec 26th, 2006
YES, u can install INFORMATICA POWER CENTER 7.1.1 version on WINXP.It works fine.check out once by creating a new DSN.
-
-
Why session fails when running a workflow
Could anyone tell me why session fails when running a workflow? I do not see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.
rohit1505
- Mar 21st, 2011
Read the session log file, and also do check weather your target table is generated or not because if you are getting the result as 'now rows selected' then this might be one of the reason. You need to generate target table in designer itself.
anupama2000
- May 26th, 2008
Hi,Kamal1.check the preview data option in your source in mapping if the data comes to your srce then go for second stepif the data is not previewed check the source DSN2.check username of your sourc...
-
How to load time dimension?
manisha.sinha
- Dec 29th, 2006
create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...
kumar
- Sep 28th, 2006
For loading data in to other dimensions we have respective tables in the oltp systems..But for time dimension we have only one base in the OLTP database. Based on that we have to load time dimension. ...
-
For homogeneous sources we use Source Qualifier to join the sources? Why not the joiner transformation.
vinodh259
- May 11th, 2007
who said that we cant use joiner for homogenous sources. but the thing is performace becomes bad if we use joiner transformation after source qualifier.? it is for the fact that for any sources (homo&...
Phani
- Feb 16th, 2007
This is because performing join at database level is must faster than performing join at session level. So, if source tables r originating from the same database( say relational) prefer join in the source qualifier transformation than for opting joiner transformation.regards,Phani...
-
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...
-
You transfer 100000 rows to target but some records get discard. How wil you trace them? and where its get loaded?
sreedhark26
- Jan 6th, 2007
Session failed after loading 10000 records, opb_server_recovry file loads the records, it maintains the record id, correct the error again run the session , session will take 10001 record on words
ravi guturi
- Jan 5th, 2007
Yes, we will find out discarded rows by using row indicator and coloum indicator..Row inidicator:DONTD-validO-overflowN-nullT-truncateColumn Indicator:01230-insert1-update2-delete
-
What happens if cache name is not entered in the lookup ?
-
How to get 25 of 100 fields table is there any transformation available in informatica i know router/filter or any other?
raju
- Nov 19th, 2006
I faced this qus in accenture interview
-
What is DTM process?
itisanimesh
- Nov 6th, 2009
The Load Manager creates one DTM process for each session in the workflow. It performs the following tasks: Reads session information from the repository. Expands the server, session, and mapping...
dl_mstr
- Feb 11th, 2008
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.
-
-
What is Data Transformation Manager?
After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process is to create and manage threads that carry out the session tasks.· The DTM allocates process memory for the session and divide it into buffers. This is also known as buffer memory. It creates the main thread,...
Read Best Answer
Editorial / Best Answer
Goush- Member Since May-2007 | May 15th, 2007
When the workflow reaches a session, the Integration Service process starts
the DTM process. The DTM is the process associated with the session and it
performs the following tasks:
1. Retrieves and validates session information from the repository.
2. Performs pushdown optimization when the session is configured for
pushdown optimization.
3. Adds partitions to the session when the session is configured for dynamic
partitioning.
4. Forms partition groups when the session is configured to run on a grid.
5. Expands the service process variables, session, and mapping variables and
parameters.
6. Creates the session log.
7. Validates source and target code pages.
8. Verifies connection object permissions.
9. Runs pre-session shell commands, stored procedures and SQL.
10. Sends a request to start worker DTM processes on other nodes when the
session is configured to run on a grid.
11. Creates and runs mapping, reader, writer, and transformation threads to
extract, transform, and load data.
12. Runs post-session stored procedures, SQL, and shell commands
13. Sends post-session email.
jayapraveen
- Oct 4th, 2010
load manager creates the DTM(data transformation manager)in the work flow manager by the informatica server ,here DTM creates two threads 1.reader thread2.writer threadDTM reads the data from &nb...
chandrarekha
- Sep 6th, 2007
Load manager and DTM are the components of Informatica server. Load manager manages the load on the server by maintaining a queue of sessions and release the session based on first come and firs...
-
How can you create or import flat file definition in to the warehouse designer?
U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If u want to load to a file,configure the session to write to a flat...
ASHOK1324
- Apr 18th, 2009
1] Add the metadata of source file into Informatica designer using source analyzer and save source file definition in the repository.2] When we drag the source file definition into warehouse desig...
Latha.
- Sep 3rd, 2007
While creating flatfiles manually, we drag and drop the structure from SQ if the structure we need is the same as of source, for this we need to check-in the source and then drag and drop it into the Flatfile, if not all the columns in the source will be changed as primary keys.
-
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
Informatica Interview Questions
Read Best Answer
Ans