Create a mapping which contains 2 target tables. When the
session runs for the first time it shud load Target table 1
and when it runs for second time it shud load Target
table 2.
- 7 Answers
- 13787 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / zak
Hi Babu,
Your logic works fine if you update the MVAR mapping
variable manually before you run the session. Is there a
way to update the MVAR within the mapping??
Thanks for your reply:)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the function of aggregator transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How to configure mapping in informatica?
How do you load only null records into target? Explain through mapping flow.
What is informatica powercenter repository?
What is dimensional table? Explain the different dimensions.
What is the surrogate key?
What is the benefit of partitioning a session?
What are Dimensional table?
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
Explain the types of transformations?
What do you mean by channel change?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the difference between mapping parameter and mapping variable?
How can you differentiate between powercenter and power map?
