Answer Posted / sarvesh
create table newtable as select distinct * from original
tablename;
by doing this we can elimate the duplicate rows
| Is This Answer Correct ? | 6 Yes | 10 No |
Post New Answer View All Answers
How we can use union transformation?
Describe data concatenation?
What is a rank transform?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is Session and Batches?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is source qualifier transformation in informatica?
According to his methodology what all you need before you build a datawarehouse
What are multi-group transformations?
Explain lookup transformation in informatica
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain direct and indirect flat file loading (source file type) - informatica
What are the reusable transformations?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the types of caches in lookup?