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
permutations of mapplet
How to do unit testing in informatica? How to load data in informatica ?
Can you generate sequence numbers without using the sequence generator transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
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?
Where do we use mapping variables in informatica?
Why union transformation is an active transformation?
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
Define mapplet?
What is update strategy transform?
What could be the possible resons of locks by user?
How identifying bottlenecks in various components of informatica and resolving them?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
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