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
- 40797 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 informatica? Why do we need it?
When do you use sql override in a lookup transformation?
What is an aggregator transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is meant by target load plan?
Performance tuning( what you did in performance tuning)
Mention few power centre client applications with their basic purpose?
Explain the etl program with few examples.
What is a difference between complete, stop and abort?
differences between service based and product based?
What is a surrogate key?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain how to import oracle sequence into informatica?
What are the types of schemas we have in data warehouse.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
