IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
Answer Posted / saritha
You can use Joiner transformation to design scd Type1
manually. Import target as source and use joiner
transformation. Use expression to insert and update the
rows into target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
how many types of dimensions are available in informatica?
What is the use of an aggregator cache file?
What is olap (on-line analytical processing?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What does role playing dimension mean?
Explain about Informatica server process that how it works relates to mapping variables?
Explain what are the different versions of informatica?
How do you load unique records into one target table and duplicate records into a different target table?
Explain sessions. Explain how batches are used to combine executions?
Describe an informatica powercenter?
How many number of sessions can one group in batches?
What is informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is complex mapping?