I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is facttable granularity?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
How to load a Dimension ? and how to load a fact table?
Where should yoU place the flat file to import the flat file defintion to the designer?
Which kind of index is preferred in DWH?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
What is parallel processing in informatica?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
Name 4 output files that informatica server creates during session running?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
select count(1) from emp? what is the o/p?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?