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 / sujana
by using scd type2 v can do dis
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
how to create user defined function (udf) in informatica
Define pmcmd command?
can we override a native sql query within informatica? How do we do it?
What are the differences between oltp and olap?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to elaborate powercenter integration service?
Explain the pipeline partition with real time example?
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?
What is Cognos script editor?
Explain what are the different types of transformation available in informatica.
I have a flat file, want to reverse the contents of the flat file
Suppose we do not group by on any ports of the aggregator what will be the output?
What are ETL Tools?
How do you migrate data from one environment to another?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???