IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
- 4 Answers
- 19596 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 |
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
what is filelist concept in informatica
What are the types of error logs available in Informatica?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
what are the perameter and variable?
What are the issues you have faced in your project? How did you overcome those issues?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
how can we load starting with 11th record of a table from source to target
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
how to get flatfile containg 10 records half records one target another half another target
Teradata 
