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
- 16172 Views
- I also Faced
- E-Mail Answers
Answer Posted / shrikant
Hello,
If I understand this question properly, it says that the
no. of "Source" columns are changing.
I do not agree with this scenario. Probably in
Datawarehousing, you won't find such a design. As far as
DWH is concerned, it takes the data from the OLTP systems &
after performing some operations (E-extract, T- transform)
it finally loads the data in some targets.
Here, as per the question, the question itself arises for
the OLTP design. No any OLTP (or database design principal)
system suggests a varying number of columns.
So, please do not get confused by such trivial kind of
questions. DWH is a very disciplined subject & it follows a
very good standards. Please go through the concepts first.
You will get a clear picture of DWH then.
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
Explain the different dimensions.
What are the features of complex mapping?
How do you handle two sessions in Informatica
What is joiner transformation in informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Different sorts of metadata that stores in the storage facility?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a stored procedure transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to update or delete the rows in a target, which do not have key fields?
tell me 5 session failure in real time how can you solve that in your project?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How big was your fact table
What can we do to improve the performance of informatica aggregator transformation?
