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 |
what type of problem you faced insales project or insurance project
What is the difference between SOURCE and TARGET BASED COMMITS?
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?
wht is cdc?how to use it in creation of mappings?
How do you do error handling in Informatica?
What is the difference Between Mapping parameter and variable
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?
Where is metadata stored?
What are the basic needs to join two sources in a source qualifier?
What is powercenter on grid?
Explain Dataware house architecture .how data flow from intial to end?
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out