IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
Answers were Sorted based on User's Feedback
Answer / shashiall
plz..use "update else insert" in the properties of session.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / saritha
You can use Joiner transformation to design scd Type1
manually. Import target as source and use joiner
transformation. Use expression to insert and update the
rows into target.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different options available for update strategy?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the difference between informatica 7.0 and 8.0?
How might you approve all mappings in the archive all the while?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
What is update override?
What are the measure objects?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
what is the Default Source Option For Update Strategy Transformation?
what is the gap analysis?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What is sequence generator transformation in informatica?