how to send unique records to one target and duplicate
records to another target by using dynamic lookup cache?????
please explain me briefly///(when we use this we look up on
which target unique target ya duplicate target)
- 3 Answers
- 11243 Views
- Cognizant, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / dave
May be i understood question wrong , but :
For unique records you can use in Source Qualifier SQL with
having count condition = 1 to cut the unique records to one
target
And for second target same query but with >1 condition
---
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What are the different components of powercenter?
State the limitations where we cannot use joiner in the mapping pipeline?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is exclusive and normal mode for repository services?
Write the prerequisite tasks to achieve the session partition?
What is joiner change?
what is degenerated dimension?
tell me 5 session failure in real time how can you solve that in your project?
Tell me about Propagate functions in informatica
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to create the source and target database connections in server manager?
What is meant by a domain?
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.
How to partition the Session?
