Interested to Buy Any Domain ? << Click Here >> for more details...
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
- 4 Answers
- 20747 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to open an older version of an object in the workspace?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a filter transformation and why it is an active one?
Explain sessions?
How do you load alternate records into different tables through mapping flow?
What is the status code in stored procedure transformation?
How do you update the records with or without using update strategy?
What are the tasks that source qualifier perform?
What is the benefit of session partitioning?
Difference between Data and Index Caches?
What is rank transformation in informatica
What is a sorter transformation?
What is the way to execute pl/sql script using informatica mapping?
As union transformation gives UNION ALL output, how you will get the UNION output?
tell me about your project functionality
