Answer Posted / chandrasekar
Whenever an OLTP records update or insert in the source
,then the records are loaded in to target as a new record.
Using SCD type 2 we can acheive the incremental load.
If it wrong means chandranmca2007@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is an unconnected transformation?
What are the measure objects?
what is diff b/t sorter t/r and agg have the option sorter property...
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the pipeline partition with real time example?
What do you mean incremental aggregation?
Why do we need informatica?
Name the different lookup cache(s)?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the advantages of using informatica as an etl tool over teradata?
whats the logic to load the lower level of granularity of data to fact table.
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
Explain how to import oracle sequence into informatica?