Interested to Buy Any Domain ? << Click Here >> for more details...
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
- 4 Answers
- 20809 Views
- HP, I also Faced
- E-Mail Answers
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 is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is partioning?how many types of partinings are there
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
List the transformation in informatica.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Clarify the utilization of aggregator cache record?
what is difference between COM & DCOM?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Tell me one complex query in oracle ?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
Explain the informatica workflow?
If u r using dynamic cache lookup port will be thier in thet which option u will select
Teradata 
