How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?
Answer Posted / prasad
u can use unix command in pre session as sort -u file1
>newfile
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Define pmcmd command?
Enlist the tasks for which source qualifier transformation is used.
What is meant by LDAP users?
How can you generate reports in informatica?
Mention some types of transformation?
Mention few power centre client applications with their basic purpose?
Can you use flat files in Mapplets.
What are connected or unconnected transformations?
What is fact table? Explain the different kinds of facts.
generate date / time dimension in informatica
What you know about transaction control transformation?
What is union transformation in informatica?
What is meant by a domain?