hw cn v elimate dublicate values from lookup without
overriding sql?
Answer Posted / preeti
hi,if I understand this question correctly,lookup itself
eliminate duplicate rows by having options like First
Value,Last Value.So whenever there are more than one row
for matching lookup condition then it gets eliminated by
first value.last Value option.Let me know if I am wrong
Is This Answer Correct ? | 33 Yes | 2 No |
Post New Answer View All Answers
What is a predefined event?
Explain direct and indirect flat file loading (source file type) - informatica
How many number of sessions can one group in batches?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
what is the -ve test case in your project.
what is index?how it can work in informatica
Explain sessions?
What are connected or unconnected transformations?
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.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Name the different lookup cache(s)?
How do you take back up of repository?