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
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the Process to creating lookup transformation in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is session task and command task?
What is informatica powercenter repository?
Describe data concatenation?
What is parallel processing in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
EXL informatica Questions
Differentiate between source qualifier and filter transformation?
Explain constraint based loading in informatica
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are mapplets? How is it different from a Reusable Transformation?
What does refresh system mean, and what are its distinctive choice?