Interested to Buy Any Domain ? << Click Here >> for more details...
2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?
- 2 Answers
- 8587 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankur saini er.ankur861@gmail.
we use dynamic lookups in case we have duplicates in source
and source says that they cnt remove them as per
requirement ...in that case we have to settle for:
say we have a reocrd id=1 , name=a
id=1 , name=b
so depending upon the PI id this is a duplicate so using
dynamic lookup when firts record comes the lookup cache
will have id=1 , name=a
again will duplkicate row will come then it gets updated to
id=1 , name=b
so finally only last record from the quplicates will be
lloaded in the target
| Is This Answer Correct ? | 2 Yes | 0 No |
How can you access the remote source into your session?
How many repositories can we create in Informatica?
What is meant by incremental aggregation?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
What are the different threads in DTM process?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
scd methodology?
why we use stored procedure transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What does update strategy mean, and what are the different option of it?
What is tracing level and what are the types of tracing level?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
Teradata 
