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 ...
What are the locks with respect to mappings?How do you manually lock or unlock the mappings for chages?
Latest Answer: Datawarehousing projects are different from the traditional OLTP project. First of all they are ongoing. A datawarehouse project is never "complete". Here most of the time the business users would say - "give us the data and then we will ...
Latest Answer: we do. we have to update or insert a row in the target depending upon the data from the sources. so inorder to split the rows either to update or insert into the target table we use the lookup transformation in reference to target table and compared with ...
Latest Answer: the lookup table is used to split the data by comparing the source and target data. the data is branched accordingly whether to update or insert ...
Would you recommend using an orderby clause as part of a lookup sql override for a cached lookup data set in informatica
Latest Answer: could you please eloborate what is BRD ...
Latest Answer: 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. ...
Latest Answer: 1. We can not use SQL override. We have to use transformations for all our requirements2. Testing the flat files is a very tedious job3. The file format (source/target definition) should match exactly with the format of data file. Most of the time erroneous ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
