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.
Latest Answer: By default there will be no name for the cache in lookup transformation. Everytime you run the session, the cache will be rebuilt. If you give a name to it, it is called Persistent Cache. In this case, the first time you run the ...
Latest Answer: Hi,Data mart is a part of the data warehouse.for example In an organization we can manage Employee personal information as one data mart and Project information as one data mart,one data ware house may have any number of data marts.The size of the data ...
Latest Answer: First column of the bad file indicates row -indicator and second column indicates column indicatorRow indicator : Row indicator tells the writer what to do with the row of wrong dataRow indicator ...
Latest Answer: hi PMCMD means program command line utility. it is a program command line utility to communicate with informatica server. PMCMD performs following tasks ...
Latest Answer: hi, when the informatica server starts a recovery session it reads the opb_srvr_recovery table and notes the rowid of the last row commited to ...
Latest Answer: Commit interval is a interval in which the Informatica server loads the data into the target. ...
Latest Answer: If you take a ex:EMP TABLEÂ having the duplicate recordsThe query isSELECT *FROM EMP WHERE EMPNO IN SELECT EMPNO FROM EMP GROUP BY EMPNO HAVING COUNT(*)>1;Sanjeeva Reddy ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>

Go Top