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 are the fact table & dimensional table in pharmaceutical and hospotal related products???
What will be the approach?
How to differentiate between the active and passive transformations?
Where do we use mapping variables in informatica?
Design time, run time. If you don't create parameter what will happen
what are the deliverables?in your project?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the popular informatica products?
differences between service based and product based?
What is dimensional table? Explain the different dimensions.
What is Session and Batches?
Why is sorter an active transformation?
Reusable transformation and shortcut differences
What is enterprise data warehousing?
pmscmd startworkflow -sv