What is informatica etl tool?
No Answer is Posted For this Question
Be the First to Post Answer
How to identify this row for insert and this row for update in dynamic lookup cache
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
how do u fnd the duplicate rows and how to delete the duplicate rows?
What are the two modes of datamovement in informatica sever?
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 How to do the above scenario in Informatica.
Where are the source flat files kept before running the session?
How can you recover the session in sequential batches?
how many data models u have done in informatica project?
What is a taget load order?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is lookup ?