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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the surrogate key?

638


How does the aggregator transformation handle null values?

697


Differentiate between a repository server and a powerhouse?

577


Explain your project of banking domian.

1218


what is size of u r database?

1848






How do you load only null records into target? Explain through mapping flow.

1506


How do you load alternate records into different tables through mapping flow?

1294


What are the mapping parameters and mapping variables?

624


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

602


Plz can any one say me how to get the informatica certification materials and dumps

1598


What do you mean incremental aggregation?

623


How to join three sources using joiner? Explain though mapping flow.

697


if we have a delimiters at unwanted places in a flat file how can we over come those.

1570


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7767


Explain dynamic target flat file name generation in informatica

648