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 new features of informatica 9.x in developer level?
Could you explain what is enterprise data warehouse?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is enterprise data warehousing?
What is a stored procedure transformation?
what is the hint? how to use it to reduce the query processing in program?
Explain the different lookup methods used in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Performance tuning( what you did in performance tuning)
Explain the aggregator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
How do you load first and last records into target table?
Under which circumstances, informatica server creates reject files?
how many types of dimensions are available in informatica?
Why do you use Mapping Parameter and mapping variable?