Interested to Buy Any Domain ? << Click Here >> for more details...
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
- 4 Answers
- 21130 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
When do you use sql override in a lookup transformation?
What is a surrogate key?
what is unit testing?tell me proceedure
What is a router transformation?
Explain what transformation and how many are there in informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is the difference between informatica6.1 and infomatica7.1
What is option by which we can run all the sessions in a batch simultaneously?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Do you find any difficulty while working with flat files as source and target?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the Rank index port in Rank transformation?
Define sessions in informatica etl?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain scd type 3 through mapping.
