In a mapping i have three dimensions. If i want to pass a
same surrogate key value to all the three dimensions by
using one sequence generator is possible?If the mapping is
containing single flow? And in the same case if the mapping
is contaning 3 flows for the three dimensions then by using
one sequence generator can we populate surrogate key (same
value) to all the three dimensions?
Answer Posted / abhishek
yes offcourse we can do it
for understandi this you can refer SCD2 version it haapens
same like ur qustion
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
is it possible to index the data in cache of lkp transformation ?
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
Can we create multiple integration service on single repository?
explain abt ur project architecture?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to create or import flat file definition in to the warehouse designer?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How do you convert single row from source into three rows into target?
What is persistent lookup cache?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is different between the data warehouse and data mart?
What do you mean incremental aggregation?
Define mapplet?
What are the components of Informatica? And what is the purpose of each?