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
- 6202 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 |
what is the main advantage of unconnected lookup
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What is decode in informatica?
How to jion 2 tables, without using any condition?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
What is the Hierarchy of DWH?
When do you use sql override in a lookup transformation?
What is repository manager?
How many repositories can we create in Informatica?
what is mapping override?
Teradata 
