-
What is the look up transformation?
Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.
Sridhar Tirukovela
- Jan 2nd, 2007
Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which...
sithusithu
- Jan 19th, 2006
Use a Lookup transformation in your mapping to look up data in a relational table, view, or synonym. Import a lookup definition from any relational database to which both the Informatica Client and Server can connect. You can use multiple Lookup transformations in a mapping.Cheers,Sithu
-
When do u we use dynamic cache and when do we use static cache in an connected and unconnected lookup transformation
priyamayee
- Jun 8th, 2006
Hii, We use dynamic cache only for connected lookup. We use dynamic cache to check whether the record already exists in the target table are not. And depending on that, we insert,update or delete the ...
-
Architectural difference between informatica 6.1 and 7.1.
sreedhark26
- Jan 6th, 2007
global repository in 7.1 versionnew cutom transformation,normalizer transformation added in 7.1
muzamil
- Aug 2nd, 2006
hiFew differences or the enchancements in 7.1 which i have noticed are Versioning in 7.1, Recovery, Can lookup flat filesso these are the differences. Best RegardsMuzamil
-
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 is the event-based scheduling?
sreedhark26
- Jan 9th, 2007
event based scheduling is using for row indicator file. when u dont no where is the source data that time we use shellcommand,script, batch file to send to the local directory of the informaticaserver is waiting for row indiactor file befor running the session.
sn3508
- Oct 25th, 2006
In time based scheduling, the jobs run at the specified time. In some situations, we've to run a job based on some events like if a file arrives then only the job has to run whatever the time it is. In such cases, event based scheduling is used.
-
-
What r the basic needs to join two sources in a source qualifier?
Two sources should have primary and Foreign key relation ships. Two sources should have matching data types.
-
What is the diffrence between SCD and INCREMENTAL Aggregation?
saibabu
- Jan 11th, 2007
hi,scd means 'slowly changing dimentions'since dimention table maintains master data ,the column values occationally changed .so dimention tables are called as scd tables and the fields in the scd ta...
srinivas
- Jan 10th, 2007
Hi,HIRE ,DIMENSIONAL DATA IS STORED. NO AGGRIGATE CALCULATIONS SCD WE R USING 3 WAYS1.TYPE-1: IT'S MAINTAIN CURRENT DATA ONY2.TYPE-2: IT'S MAINTAIN CURRENT DATA + COMPLET HOSTROY RECO...
-
Where from we get the source data or how we access the source data
saibabu
- Jan 11th, 2007
Hisource data exists in OLTP systems of any form (flat file,relational database.,xml definitions.)u can acces the source data with any of the source qualifier transformationsw and normaliser tranaformation.
phani
- Jan 3rd, 2007
Hi,We get souce data in the form of excel files, flat files etc., By using source analyzer we can access the souce data
-
Explain the pipeline partition with real time example?
saibabu
- Jan 11th, 2007
PIPELINE SPECIFIES THE FLOW OF DATA FROM SOURCE TO TARGET .PIPELINE PARTISON MEANS PARTISON THE DATA BASED ON SOME KEY VALUES AND LOAD THE DATA TO TARGET UNDER CONCURRENT MODE. WHICH INPROVES THE ...
-
What is ODS?
manjunathda
- Jan 13th, 2007
An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, the contents of the ODS are updated...
manjunathda
- Jan 13th, 2007
An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, the contents of the ODS are updated throu...
-
-
Hi ,Recently in an interview they aske me what can we do in mapplets,that we cannot do in mappings? can one please answer me.Thanks for your time
lakshmi1
- Jan 16th, 2007
Hi,Mapplets is a group of reusable transformations. A mapplet can be called from multiple mappings.A mapping also contain reusable transformations. These transformations could be used in the same mappingRegards
sreedhark26
- Jan 6th, 2007
mapping is not reusable. mapplet is reusable, mapplet is different set of transformation logic.reusable mapplets we can use in many mappnings
-
How to load the time dimension using Informatica ?
monicageller
- Jan 19th, 2007
Hi Kiran,Can U plz tell me in detail how do we do that?I am a fresher in informatica...plz help.thanks.
kiran
- Dec 24th, 2006
HiUse strored procedure tranformation to load time dimention
-
-
How can we delete duplicate rows from flat files ?
Srinivas Kumar Paga
- Jan 23rd, 2007
Use Sorter Transformation and check "Distinct" option. It will remove the duplicates.
manisha.sinha
- Dec 29th, 2006
In the mapping read the flat file through a Source Definition and SQ. Apply a Sorter Transformation , in the property tab , select distinct . out put will give a sorter distinct data , hence you get r...
-
-
-
Informatica Interview Questions
Ans