-
-
What is the size of data mart?
chillkrishna
- Oct 11th, 2009
Size of the datamart completely based on your client requirements. BA's & DBA's basically decide datamart size.Hope this helps.Krishna M
Thananjayan
- Dec 6th, 2007
Hi,Data mart is a part of the data warehouse.for example In an organization we can manage Employee personal information as one data mart and Project information as one data mart,one data ware house ma...
-
What is use of UNIX in Informatica?
What is use of UNIX in Informatica? Where and how can we use UNIX shell scripts or commands to run informatica jobs or other related applications in informatica?Please tell in details as i am working on windows environment, but will be shifted to UNIX environment. Please describe in details starting from installation of informatica in UNIX to run or guide the working on informatica in Unix environment.
-
When do you use Normal Loading and the Bulk Loading, Tell the difference?
vivekvish
- Jul 24th, 2008
You would use Normal Loading when the target table is indexed and you would use bulk loading when the target table is not indexed. Running Bulk Load in an indexed table will cause the session to fail.
chandrarekha
- Sep 28th, 2007
Normal Load: It loads the records one by one, Server writes log file for each record, So it takes more time to load the data.Bulk load : It loads the number of records at a time, it does not write any log files or tracing levels, so it takes less time.
-
How to create connection for source flat file? Which session properties need to be changed?
I have to load data from DB2 flat file to MS SQL Server target tables.
nitin_2002786
- Jan 24th, 2013
First for Flat file a connection is not required.
All we need to provide is the path of the path in the mapping properties.Anil Borru
- May 28th, 2012
It will save in Informatica Server below path:
c:Informatica9.0.1serverinfa_sharedSrcFiles -
How to return more than two values from an unconnected lookup?
Amritendra kumar
- Feb 29th, 2008
Unconnected lookup only return 1 port but if you want to return 2 port then u have to play mind game mean u hav to use concatenate operator in expression editor.
-
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 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...
-
Which activities can be performed using the repository manager?
vizaik
- Nov 14th, 2007
You can use the Repository Manager to perform the following tasks:Add or remove a repository.Work with repository connections. Search for repository objects or keywords.View object dependencies. Compa...
obli prabu KV
- Oct 28th, 2007
Using repository manager*We can create folders under the repository*Create Sub Folders and Folder Management*Create Users and USer Groups*Set Security/Access Privilges to the usersand many more...
-
In case of use of dynamic lookup cache in a lookup transformation, the lookup cache gets updated first and then the target table. What happens if the target table rejects a row after it is updated in the Cache?
ggazulas
- May 27th, 2008
You wont get an error if the row is inserted in dynamic cache and it was rejected in the target table. But remember we are refering to the same table in dynamic chache, so if it is inserted in the cha...
prakash
- Nov 26th, 2007
Data in the target table does syncronize. here you wont get any error but the result will not so accurate. so update it in the trg or you can use update strategy transformation as insert after lookup
-
What are Meta Data Extenstions used in an informatica mapping? What is the significance,usage and how informatica handles them?
ORAINFO
- Nov 18th, 2008
Metadata means data about data. Metadata extension means any additional information about the data. For Example let us consider a source qualifier and then I want to put any extra info about it like d...
prabhat007
- Dec 8th, 2007
Metadata Extensions: Who created,what purpose,version number etc for future enhancements. Information about mapping for other people to better understand.Metadata information in repository can be reported using informatica metadata tool.
-
What is the use of Pre SQL & Post SQL in source qualifier and target table? How to use?
suneetharoy
- Oct 23rd, 2009
Pre SQL: The SQL query fires initially when loading to that database.Example for Pre SQL: Suppose my requirement is to load the records daily. If some updates I have to reload the records for that pa...
sekhar.ganta
- Jan 3rd, 2008
I think above answer may be not correctIn source qualifier t/r : If you write any pre sql? that statement will execute is source database connection before reading the data. If you write that query?...
-
Informatica - connect to the repository server error
I am unable to connect to the repository server in repository administrator console after registering new server
anupama2000
- May 26th, 2008
Hi,SOGOTO SERVICES BYRUN-->TYPE( SERVICES.MSC)START THE INFORMATICA SERVER AND NOW CONNECT IN REPOSITORY SERVER ADMIN CONSOLEOR CHECK THE PAASWORD THAT U HAVE GIVEN FOR REP SERVER
sakthione
- Dec 30th, 2007
Hi friend!Please follow these steps and try to connect the server; My computer properties &nbs...
-
Informatica objects File Format
What is the file extension and format of the files for the Informatica objects like Mappings, sessions etc in the repository ?
virendra.jaipur
- May 21st, 2010
If you store them in repository, it obvisouly is in terms of relational tables.But if these objects are stored/exported outside the repository, as files; that is when they are stored as xml format files.
sameer_solidcore
- Feb 20th, 2009
Repository is nothing but a database, rather a relational database, and in a relational database anything and everything is stored in tables. And tables are nothing but files with pointers. So in a re...
-
Informatica source and targets with same fields
We have one source and 3 targets with same fields i.e empno,ename in all 3 targets and source, then the 1st row in source should go to 1st target, 2nd row in source should go to 2nd target and the 3rd row in source should go to 3rd target, 4th row again to 1st target , 5th row to target2 6th row to target 3 like this we need to transfer data how is it possible?
sandeep.vaishy
- Jan 14th, 2008
First Load Data from source To One dummy table in target with SEQ Gen T/R.in SEQ Gen T/R Set min value 1 and max value 3 and check the reset option.It will load the data with new column Values 1,2,3,1...
sekhar.ganta
- Jan 3rd, 2008
here we should use router transformation with 3 groups. suppose 3 targets are target1: condition multiples of 3?????????? select * from emp where (empno,0) in (select empno,mod(rownum,3) fro...
-
Connect two sources
How to connect two sources with connecting field without using joiner and lookup?
-
Mapping variable - Mapping Parameter
What will happen when Mapping variable and Mapping parameter in Informatica is not defined or given? Where do you use mapping variable and mapping parameter?
garunchowdary
- Feb 29th, 2008
Definitely it accepts the defualt values when parameters or variables are not present.
sarun5
- Feb 18th, 2008
Thanks Deepak. But does it take any null values or any default values to run the mapping.
-
What is meant by source is changing incrementally?
What is meant by source is changing incrementally?Explain with an example?
N SRIRAM K
- Apr 14th, 2008
The data in the source is not STATIC..It may change (the no. of records - addition or subtraction) over the period of time or Session run to session run....ThxSRIRAM N
Vani_AT
- Mar 28th, 2008
I think, source is changing incrementally means new rows are getting inserted into the source. For example, If a source on day1 has 10 records; then on day2, 5 new records got added along with the pre...
-
Dimension Tables and Fact Table
How many Dimension tables can connect to a Fact table?
jryan999
- Sep 1st, 2008
The number of Dimensions depends primarily on the requirement. I have built systems with a few FOUR Dimensions on a Fact and as many as TWENTY. There is no physical limit imposed by either...
subashreddy77
- Apr 27th, 2008
Hiwe can connect as we like but it will be generally based on requirements
-
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
Informatica Interview Questions
Ans