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
- 8468 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the function of look up transformation?
How we can create indexes after completing the load process?
What is the command used to run a batch?
Write the unconnected lookup syntax and how to return more than one column.
Tell me about Propagate functions in informatica
Explain informatica architecture - version 8 / 9
What is resilience time?
Which is the t/r that builts only single cache memory?
Write the advantages of partitioning a session?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the informatica performance improvement tips
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is update strategy transform?
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.
