suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
- 4 Answers
- 9487 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / leo gilbert
Have a lookup to table T1 (should be dynamic one). If the
record already exists in T1 (i.e. duplicate) then route to
T2 else route to T1
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Define the various join types of joiner transformation?
State the differences between sql override and lookup override?
What are the types of schemas we have in data warehouse and what are the difference between them?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is an Integration service in Informatica?
What is InformaticaPowerCenter?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How can we use batches?
How to load the data from people soft hrm to people soft erm using informatica?
Explain informatica architecture - version 8 / 9
Explain scd type 3 through mapping.
Why filter transformation is an active one?
What is the use of source qualifier?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the types of transformations?
