u can use flat files in mapplet
Type: Posts; User: hanumca07; Keyword(s):
u can use flat files in mapplet
u can apply flat files in mapplet,u can't use xml files in mapplet
data is maintaind in centrally located fact tables.fact tables are centrally located and sorrounded by dimension tables
click on source anlyger,then u can select source menu,there u can see import from xml file.u can import from there before that u need to create xml file.
can u tell me wat are the new enhancementes in informatica 8.1.1 wen compare to informatica 7.1.1
u can add using following commands :
alter table tablename add column datatype(len)[defaule val] constraints;
I have source table emp in that columns are empno, ename, job, sal, comm, deptno, finally
I want to load target table as totalsal for each record (total sal=sal+comm), which transformation I have...