Latest Answer: 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 histrory of the data,for ex,The cost of the product ...
(connected & un connected)
Latest Answer: Look up transformation compares the soure with specified target table,and forwarded the records to next tranformation only matched records.If not match,it returns NULL ...
Latest Answer: Reusable transformation is a single transformatin, which can be resuable & mapplet is a set of transformations which can be reusable. ...
HiI am having 10000 records in flat file, in that there are 100 records are duplicate records..soo we want to eliminate those records..which is the best method we have to follow.RegardsMahesh Reddy
Latest Answer: Using sorter (with distinct option checked) will not tell what all records were duplicate. There is even a better way of doing it without using aggregator and all. it just uses expression transformation. ...
Latest Answer: The mapplets cant use these following transformationsxml source qualifiernormalizernon-reusable sequence generator (it can use only reusable sequence generator) ...
Latest Answer: A shortcut is a reference (link) to an object in a shared folder, these are commonly used for sources and targets that are to be shared between different environments / or projects. A shortcut is created by assigning 'Shared' status to a folder within ...
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
Latest Answer: we can do this by using mapping wizard. there are of basically two types:1)getting started wizzard2)scdgettign started wizard is used when there is no need to change the previous data.scd can hold the historical data. ...
What I am trying to determine is if I could invoke a SAS session from within Informatica's ETL product(s) in order to execute a complicated transformation written in SAS which would then return the
Latest Answer: a source definition database contain the datatypes that are used in the orginal database from which the source is extracted. where the source qualifier is used to convert the source definition datatypes to the informatica datatypes. which is easy to work ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
