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
What is the need for an etl tool?
can anyone explain me about retail domain project 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
where to store informatica rejected data?
Define enterprise data warehousing?
Do you find any difficulty while working with flat files as source and target?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain the types of transformations?
What is the use of an aggregator cache file?
What are some examples of informatica etl programs?
What is an Integration service in Informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Can u generate reports in Informatica?