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
- 6001 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 |
generate date / time dimension in informatica
major difference between normal loading and bulk loading?
What is staging area?
How to recover sessions in concurrent batches?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
how to we create datamart?
In session log thier should not be a single error how will u do
What is domain in terms of informatica?
how to load rows into fact table in data warehouse
In joiner, how to load Master table in Target?
Teradata 
