Is scd logic we have lookup right to compare the values with
source and target,instead of lookup can u have any
transformation or any way to do this?
Answers were Sorted based on User's Feedback
Answer / naga
We can write Left outerjoin with the target in Source
Qualifier itself or if ur src is file & target is Table
then using Joine(Left outer) can get the new rows loaded
into target
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / itsranjan
Hi, Joiner transformation can do the same job what lookup
does in SCD.
Is This Answer Correct ? | 1 Yes | 2 No |
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
how to get the only updated records in the target
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
performance tuning of Informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Why we require dwh in particular projects?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
What is factless fact schema?
wht is cdc?how to use it in creation of mappings?
Name the different lookup cache(s)?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,