how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / amedela chandra sekhar
SD---S.Q----EXP t/r------TGT.
add two port in exp t/r.
one is variable port v_seq expression:seq+1
one output port o_seq expression:v_seq
required ports connect to target.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Can you use flat files in Mapplets.
What is native users?
Briefly define reusable transformation?
Can we get 1st record through Informatica(without sequence number).
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
Why is sorter an active transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the uses of etl tools?
What are the different lookup cache(s)?
What is a joiner transformation?
How to elaborate tracing level?
Enterprise data warehouse your projects phase by phase explain?
What are the new features of Power Center 5.0?
What is data caches/ index caches?
What are the types of schemas we have in data warehouse and what are the difference between them?