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: 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. ...
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 ...
Latest Answer: Fact table without measure is called factless fact tablefact less fact tables are used to capture date transaction events ...
Please give suggession. This question was asked by employer recently. Thanks in advance.
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
