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 5133every 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 5047can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
2486I 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 8139My 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 6245My 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 5032how to design mapping half of source table records into one target and remaining half into another target
ABC,
8 15070there 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 6808Post New Informatica Questions
What are the components of workflow manager?
Mention few advantages of router transformation over filter transformation.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the differences between oltp and olap?
Did u used latest transformations of 8.6.0? for what?
What is the difference between a repository server and a powerhouse?
Differentiate between a database and data warehouse?
How can a transformation be made reusable?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
is it possible to index the data in cache of lkp transformation ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a filter transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
