-
Where should you place the flat file to import the flat file definition to the designer?
vishal taywade
- Sep 22nd, 2008
We can place source file any where in network, but it will consume more time to fetch data from source file, but if the source file is present on server srcfile then it will fetch data from source upto 25 times faster than previous.
abhishek_upadhyay
- Sep 18th, 2008
Basically the flat file should be stored in the src folder in the informatica server folder.Now logically it should pick up the file from any location but it gives an error of invalid identifier or no...
-
What are the meta data of source you import while importing the relational source definition from database ?
Read Best Answer
Editorial / Best Answer
Answered by: srinvas vadlakonda
- Sep 28th, 2006
Source name
Database location
Column names
Datatypes
Key constraints
srikanth
- May 11th, 2022
Column names
Sumithav29
- Jun 12th, 2009
ODBC data source, username, owner name, password. Once the connection is established, select the table.
-
What is a transforamation?
It is a repostitory object that generates,modifies or passes data.
sprajarajan
- Aug 8th, 2008
A TransFormation Is a Repository Object.That Generates,Modifies or Passes Data.The Designer Provides a Set of Transformations That perform Specific Functions.For Example An AGGREGATOR Transformation Performs Calculations On Groups Of Data.
bibhu
- Nov 10th, 2006
Transformation is a repository object of converting a given input to desired output.It can generates,modifies and passes the data.
-
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.
-
Informatica Interview Questions
Read Best Answer
Ans