2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?
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 do you join more than 3 flat files in informatica?
To achieve the session partition what r the necessary tasks u have to do?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
can we import source table without using source qualifier? if yes then how? if no then why?
Make a note of the quantity vaults made in informatica?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the Advantages of de normalized data?
What are the new features of informatica 9.x at the developer level?
Differentiate between joiner and lookup transformation?
In a sequential batch can u run the session if previous session fails?