We do have a design like this(in DWH to DM load). But to accomplish this

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?

Question Posted / suganthi

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

Please Help Members By Posting Answers For Below Questions

What is lookup transformation?

1021

Explain the different dimensions.

945

How can a transformation be made reusable?

1140

What is joiner transformation in informatica?

1031

How to update source definition?

1074

What are the guidelines to be followed while using union transformation?

1119

What is InformaticaPowerCenter?

1112

What are the conditions needed to improve the performance of informatica aggregator transformation?

1074

Informatica settings are available in which file?

975

Can you generate sequence numbers without using the sequence generator transformation?

1099

Is it possible to revert a global repository to local one and why?

1063

Design time, run time. If you don't create parameter what will happen

1826

Differentiate between reusable transformation and mapplet.

1069

Explain how to import oracle sequence into informatica?

988

What are the different options available for update strategy?

988