Interested to Buy Any Domain ? << Click Here >> for more details...
If no. of source columns is changing every time (First time
it is 10 next time it is 20 so on). How to deal with it
without changing mapping?
- 9 Answers
- 15960 Views
- I also Faced
- E-Mail Answers
Answer Posted / bidhar
If this is the requirement,then you will have to reimport
the source metadata in source analyzer and the save so that
the new columns are reflected in the mapping source.But to
pull it to target you need to join manually the pipelines.
But Such type of scenarios rarelly comes in OLAP models.A
good DWH design should be in such a way that if in future
any new columns come in the OLTP systems then DWH can
accomodate that.
For example Product Table has 20 columns in OLTP system.
Then OLAP model can have more than 20 columns for Product
Dimension(ATRIBUTE_1,ATRIBUTE_2 and so on)and populate null
values into that.
Now whenever new columns are added into the OLTP Product
table then we can simply map the new column to the ATRIBUTE
Columns,Keeping the datatypes in mind.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you remove duplicate records in informatica? And how many ways are there to do it?
Did u used latest transformations of 8.6.0? for what?
Is it possible to revert a global repository to local one and why?
Why update strategy and union transformations are active?
What are the different types of repositories created using informatica?
What are the different types of olap? Give an example?
where to store informatica rejected data? How to extract the informatica rejected data?
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
is it possible to index the data in cache of lkp transformation ?
What is the difference between a connected look up and unconnected lookup?
What is an aggregator transformation?
scenario where i can use only concurrent execution of workflow.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
