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
What is the need for an etl tool?
EXL informatica Questions
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Mention some types of transformation?
generate date / time dimension in informatica
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Differentiate between a repository server and a powerhouse?
What is meant by pre and post session shell command?
Define sessions in informatica etl?
server hot-ws270 is connect to Repository B. What does it mean?
What is the difference between Active and Passive transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a predefined event?
What are the different lookup cache(s)?
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