How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
Answer Posted / suresh
scd type 2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
What is olap (on-line analytical processing?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the fact table?
What is Session and Batches?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
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
Performance tuning( what you did in performance tuning)
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Clarify the utilization of aggregator cache record?
What is incremental aggregation?
What are pre and post-session shell commands?
What is the benefit of session partitioning?
Why is sorter an active transformation?