If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING..
CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE
RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
Answer / babu
yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.
if any thing is wrong please let me know.
Cheers,
babu
| Is This Answer Correct ? | 5 Yes | 0 No |
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
when we go for unconnected lookup transformation? and why?
explan ur project architecture?
why we r using presql&postsql in source qualifier?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
When do you use sql override in a lookup transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain what are the different versions of informatica?
What are events in workflow manager?
Three date formats are there . How to change these three into One format without using expression transformation ?