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
Explain lookup transformation source types in informatica
In informatica workflow manager, how many repositories can be created?
What is pmcmd command?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain the difference between mapping parameter and mapping variable?
How you prepared reports for OLAP?
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?
Plz can any one say me how to get the informatica certification materials and dumps
What are the informatica performance improvement tips
How we can create indexes after completing the load process?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Is it possible to use a client with different version than that of its Informatica server?
What is a filter transformation?
Can we get 1st record through Informatica(without sequence number).