IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
- 4 Answers
- 19594 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
What is decode in informatica?
While migrating the data from one environment to another environment how would you manage the connections?
How do you update the records with or without using update strategy?
Which transformation is needed while using the Cobol sources as source definitions?
What are the differences between oltp and olap?
waht type of interface is used for testing the data in informatica
Is it possible to create multiple domains on a single Informatica server?
What is the meaning of up gradation of repository?
Explain sql transformation in script mode examples in informatica
Explain the tuning lookup transformation - informatica
How many input parameters can exist in an unconnected lookup?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
