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
- 41689 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
What is joiner transformation?
What is workflow monitor?
Briefly define reusable transformation?
What does reusable transformation mean?
Enlist the advantages of informatica.
How to update source definition?
What are the types of data warehouses?
What is flashback table ? Advance thanks
What are the components of workflow manager?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Where is metadata stored?
How many ways a relational source definition can be updated and what are they?
What is confirmed fact in dataware housing?
How do you convert single row from source into three rows into target?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
