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?

Answers were Sorted based on User's Feedback



If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / 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

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / santosh sinha

This is really a confusing question and raise question on
OLTP design butIf we are not changing the design of column
which is used in our mapping then it will not effect the
mapping so increasing the no of column will not effect.

Is This Answer Correct ?    2 Yes 0 No

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / sam

If your Source is XML this kind of scenario will come.Take
the exact XML DDL (max number of columns)as a source
defination.

Is This Answer Correct ?    0 Yes 0 No

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / suganthi

We do have a design like this(in DWH to DM load). But to
accomplish this we have created a procedure to add new
columns in teh table.

Is This Answer Correct ?    0 Yes 0 No

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / 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

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / arnab

This should not happen when executing a datawarehousing
project , This reflects poor design and poor visualisation
of the requirements

The safest way to handle this is re-import the source
definition, someone suggested create a source with the
maxinmum number of columns , there is something called
quality of code and if someone codes like this it is really
a bad example of informatica coding

Is This Answer Correct ?    0 Yes 0 No

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / srinu

Some one is not agree with Sathish Rajaiah
answer(1 No)ABOVE answer.
Let me Explain Why ?

Is This Answer Correct ?    0 Yes 1 No

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / rekha

I THINK U CAN DO IT BY MAPPING PARAMETERS

Is This Answer Correct ?    0 Yes 3 No

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). Ho..

Answer / sathish rajaiah

Create source defination with maximum (depends on the max
numbers of columns u get in the source) number of fields
and use that in the mapping.
ex: create source defiantion with 20 fields and use this in
mapping this wil handle source comes with columns btween 1
to 20.

Note : Above wrks only for flat file sourcse not fr RDBMS
sources

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More Informatica Interview Questions

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,


What are limitations of joiner transformation?

2 Answers   Exilant, TCS,


What happens if we dont select data driven option?

2 Answers   Zensar,


what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  






I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,


What you know about transaction control transformation?

0 Answers  


How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,


my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,


how to improve performence by using sorted input in aggrigator t/r.

2 Answers  


What are the performance considerations when working with aggregator transformation?

0 Answers  


On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  


Categories