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
- 15856 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
What is session task and command task?
Explain pmcmd command usage in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Why do we need informatica?
Explain informatica architecture - version 8 / 9
What is exclusive and normal mode for repository services?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How union transformation is used?
what is the -ve test case in your project.
What is informatica powercenter repository?
what is mean by complex business rule ?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the commit type if you have a transaction control transformation in the mapping?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is deployment group?
