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 is Target Update Override? What is the Use ?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the main features of Oracle 8i with context to datawarehouse?
How an expression transformation differs from aggregator transformation?
What is meta data and system catalog?
what is mean by complex business rule ?
what is target load plan
What is surrogate key?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is enterprise data warehousing?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,