how will you remove the duplicate records from flat file
without using sorter?

Answer Posted / suren

by setting option distinct option

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

permutations of mapplet

2013


How to do unit testing in informatica? How to load data in informatica ?

625


Can you generate sequence numbers without using the sequence generator transformation?

576


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

665


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1799






My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5511


Where do we use mapping variables in informatica?

596


Why union transformation is an active transformation?

630


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1848


Define mapplet?

607


What is update strategy transform?

546


What could be the possible resons of locks by user?

644


How identifying bottlenecks in various components of informatica and resolving them?

561


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1506


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

6427