Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 41247 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / usha
1st method by using expression transformation by adding
variable ports.
2nd method by using dynamicLKP we can load UNIQ records to
one taget table and DUPLICATE records to other target table
newLKProw=1(Insert)
newlkprow=0(if there is no difference in associate ports)
UNIQ records
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
Is it possible to revert a global repository to local one and why?
4 yrs etl devloper roles and responsibilities?any body give solutions
where to store informatica rejected data? How to extract the informatica rejected data?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is dynamic cache?
Explain about Informatica server process that how it works relates to mapping variables?
What are the tasks that source qualifier perform?
What is data transformation manager process?
Define enterprise data warehousing?
Tell me about MD5 functions in informatica
Is there any target staging area in informatica not staging area
What is the difference between router and filter?
What is union transformation in informatica?
What is the difference between informatica 7.0 and 8.0?
Mention few advantages of router transformation over filter transformation.
