performance wise which one is better in joiner and lookup transformation?why?explain clearly?
IBM,
1 4504every 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 4415can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
2133I 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 6672My 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 4978My 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 4124how to design mapping half of source table records into one target and remaining half into another target
ABC,
8 12699there 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 5728Post New Informatica Questions
Explain the shared cache and re-cache?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Difference between Data and Index Caches?
What are the different transaction levels available in transaction control transformation?
What is decode in static cache?
What is deployment group?
In development project what is the process to follow for an etl developer from day1
Explain the informatica workflow?
What are the guidelines to be followed while using union transformation?
How to handle decimal places while importing a flatfile into informatica?
How we can create indexes after completing the loan process?
What is meant by pre and post session shell command?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com