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 the need of an ETL tool?

1046

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1217

what is the complex transformation you used in informatica

2535

If informatica has its scheduler why using third party scheduler?

1214

wat are deployement groups in informatica, how it will be used for developers

1685

tell me 5 session failure in real time how can you solve that in your project?

2215

What is parallel processing in informatica?

1644

Explain target update override in informatica

1061

Define sessions in informatica etl?

984

Describe the impact of several join conditions and join order in a joiner transformation?

1023

What is the Rank index port in Rank transformation?

1026

What is an Integration service in Informatica?

1094

Write the advantages of partitioning a session?

1234

What is a dimensional model?

947

What is workflow monitor?

1013