performance wise which one is better in joiner and lookup transformation?why?explain clearly?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
if i am having 10 records in source, i want 20 records in target...how will you do it13 11275
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project1689
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?5 4933
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?3 3818
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?2 3156
how to design mapping half of source table records into one target and remaining half into another target
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation4 4442
Mention few power centre client applications with their basic purpose?
Explain the tuning lookup transformation - informatica
tell me about your project functionality
What is meant by incremental aggregation?
What is rank transform?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
On which transformations you created partitions in your project?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the need for an etl tool?
difference between repository database and repository service?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the main issues while working with flat files as source and as targets ?
Explain the types of transformations?
What is the difference between a connected look up and unconnected lookup?
Can we create a Integration service without a Repository service and vice versa?