Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
IBM,
1 5327every 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.
IBM,
1 5203can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
2579I 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 8532My 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 6532My 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 5229how to design mapping half of source table records into one target and remaining half into another target
ABC,
8 15619there 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 transformation
4 7071Post New Informatica Questions
Explain joiner transformation in informatica
What you know about transaction control transformation?
What is a difference between complete, stop and abort?
Explain the informatica workflow?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
explain one complex mapping with logic? sales project?
What is data transformation manager process?
Mention few power centre client applications with their basic purpose?
is it possible to index the data in cache of lkp transformation ?
What are the components of Informatica? And what is the purpose of each?
What is an active transformation?
What are pre and post-session shell commands?
Differences between connected and unconnected lookup?
Explain the shared cache and re-cache?
What is mapplet in informatica?
