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
What is mapplet in informatica?
What is rank transformation in informatica
Global and Local shortcuts. Advantages.
How can a transformation be made reusable?
Define the various join types of joiner transformation?
What is intricate mapping?
what is the size of your data warehousing?
What is a joiner transformation and why it is an active one?
What are mapplets? How is it different from a Reusable Transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to update source definition?
How many dimensions are there in informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the way to execute pl/sql script using informatica mapping?