-
What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformation error(2) A reusable unconnected Lookup can not have more than one instance in a mapping(3) An unconnected Lookup transformation does not support user-defined default values(4) An unconnected Lookup transformation does not support a static lookup cache
prashant.baranwal
- Sep 19th, 2010
What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformati...
vivek.gce
- Oct 16th, 2008
If there is no match in the Lookup condition, the Informatica server returns a transformation error.
-
Event Wait
What is the use of event wait?
sugato.sam
- Sep 22nd, 2010
Event wait is a task created in Informatica to look out for events such as waiting for a file in?the specified directory of the server. Once this task is completed, another workflow dependent on this task will get started.
nagadurgaraju
- Aug 27th, 2010
Event wait is used for loading data proper way, removing deadlock while using schemas.
-
Find Mapping or Session Errors
How will you find the errors in mapping or session by sessionlog. What are the alternative options to know the errors?
reshhhhhh
- Sep 23rd, 2010
The sessionlog will give the details of the complete working of the session. With this you can find out where the session failed. In addition session log will also give an error number to provide the type of error that has occurred.Other option to find the error is to debug the session.
-
What is Code Page used for?
Code Page is used to identify characters that might be in different languages. If you are importing Japanese data into mapping, u must select the Japanese code page of source data.
reshhhhhh
- Sep 23rd, 2010
The code page influences the way the application stores, recieves and sends the data. Code page is basically to convert any language to the language that the system understands.
-
Trace Discarded Data
You transfer 100000 rows to target but some records get discarded, How will you trace them and where its get loaded?
sakshi.chopra
- Sep 26th, 2010
The discarded records can be traced from Reject file. Also optionally you can choose Relational database error logging and the discarded records can be traced from error log tables generated by Integr...
-
Source Qualifier
What is a Source Qualifier?
jayapraveen
- Oct 2nd, 2010
Source qualifier is nothing?but a filter and it is an active transformation, it is used to join the data coming from homogeneous database the best practice of the mapping is using expression before other transformation after the source qualifier.
-
Data Loading While Session Failed
If there are 10000 records and while loading, if the session fails in between, how will you load the remaining data?
reddykuruganti
- Jun 7th, 2010
Simply you can restart the session, by selecting truncate table option in the session properties.
-
How does Informatica get sources from IBM MQ Series
-
What is redo log file in Informatica?
jayapraveen
- Oct 4th, 2010
Redo log file keeps the value when the "commit"command executes and replaces the value with new value.
satoru
- Jun 30th, 2010
In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Before a user receives a "Commit complete" message,...
-
Sorted Input option in Incremental Aggregation
Why should not we use sorted input option when using Incremental Aggregation?
jayapraveen
- Oct 4th, 2010
Because of the performance tunning, because here the duplication of the data is sorted in the bginining of the aggregation itself so index cache and data cache ?is reduced so the performance is good.
ahammed
- Jul 21st, 2010
When you are selecting sorted input the data will be sorted and at the same time last record key value will be stored in repository. After that days or months passing on some new records will be ...
-
Employee datawarehouse
I want to know what are the steps to be followed to create a employee datawarehouse.What actions needs to be performed.
-
How many mappings you have done in your project(in a banking)?
jayapraveen
- Oct 12th, 2010
In a banking project if we are dealing with a Customer information ModuleThen we require4 dimensions7 Fact tablesminimum of 45 mappings requiredsize of Database is 9GB required
Whatever
- Mar 19th, 2007
Exactly 93.133
-
1)how can we delete the cache files while we using aggregator transformaation?2)exlain about cache files handling in informatica3) there are two flat files and the two flat files contain two fileds as states.both the flat files contain duplicates how to eliminate this duplicates?4) can we use lookup transformation with out using source qualifier transformation?
jayapraveen
- Oct 13th, 2010
1.I think DTM remes the Cache files after successful loading the data into target2.a.persistent cache b.staic cache c.shared cache d.dynamic cache3.sorter befo...
chandrarekha
- Sep 28th, 2007
After the session executes,??DTM removes?the cache memory and deletes cachefiles Incase of persistant cache and incremtal aggregation cache files are saved.Generally cache files are created in Info...
-
Check Record History
How do you check if a record is a history record or a fresh record?
shiva4mba
- Oct 13th, 2010
As per my knowledge take a lookup on the target and check with their warehouse keys in the lookup condition
-
How to retrieve distinct records from 'flatfile' source ?
HP Interview Question - How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it possible? How?
shiva4mba
- Oct 13th, 2010
Yes it is possible Use aggregator after the source qualifierand put all the ports as group byit will give distinct records only
-
If a record with 40 data type size from oracle& 100 from siebel (source) but target data type size is 50 , then how informatica server handles this situation?
shiva4mba
- Oct 13th, 2010
As per my knowledge the session will run successfully and the records with different datatype sizes will be skipped.This is in oracle and I am not sure about siebel.Thankx
-
In Source Qualifier and in Target I have 1,2,3 row and I want to insert 4,5 records in source and I want them in target also? What is the procedure to load them?
jayapraveen
- Oct 14th, 2010
I think this can be done by incremental aggregation at source side and target side
sanjeev
- Aug 6th, 2007
I have one more idea. I think it is right.In source qualifier we have a pre SQL and post SQL. using the pre SQL we can insert 4 and 5 records there.Sanjeev
-
What is surrogate key ? how many surrogate key used in ur dimensions?
jayapraveen
- Oct 14th, 2010
SURROGATE KEY IS NOTHING BUT WHAT A PRIMARY KEY IS USED IN AN TRANSACTION DATABASE ,GENERALLY THIS COME IN PICTURE WHEN THE DATA IS UPDATING REGULARLY IN THE TABLE THIS MAKES THE TABLE INCONSISTENT SO...
sn3508
- Oct 25th, 2006
Surrogate key or warehouse key acts like a composite primary key. If the target doesn't have a unique key, the surrogate key helps to address a particular row. It is like a primary key in the target.
-
What is the architecture of any Data warehousing project? what is the flow?
jayapraveen
- Oct 18th, 2010
architecture is like1. Source Systems: Like Mainframe,Oracle,People soft,DB2.2. Landing tables: These are tables act like source. Usedfor easy to access, for backup purpose, as reusable forother mappi...
-
Single Level Transformation
Why single level and nested expressions is not supported in same Aggregation transformation?
gopalzoro
- Oct 20th, 2010
If an Aggregator transformation contains a single-level function in any output port, you cannot use a nested function in any other port in that transformation. When you include single-level and nested...
Informatica Interview Questions
Ans