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
- 15590 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
How can we improve session performance in aggregator transformation?
Different circumstance which drives informatica server to expel records?
list out all the transformations which use cache?
Which transformation is needed while using the Cobol sources as source definitions?
How to delete duplicate row using informatica?
How we can create indexes after completing the loan process?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is event and what are the tasks related to it?
What are the designer tools for creating transformations?
What are the different lookup cache(s)?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Where is metadata stored?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the difference between stop and abort in informatica
What is pmcmd command?
