Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5970 Views
- I also Faced
- E-Mail Answers
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 |
Define Incremental Aggregation?
what is the difference between informatica6.1 and infomatica7.1
What is informatica powercenter repository?
What is CHECK-IN CHECK-OUT. Please explane me?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
What is resilience time?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
What is the use of transformation?
without dynamic lookup transformation how to insert new rows and update existing rows?
What is a difference between complete, stop and abort?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
how can you load data into target table without leading zeor's
Teradata 
