how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
Answer Posted / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
What is dynamic cache?
What is depict expression change?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
draw informatica architecture 8.6 ?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded 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
How to generate sequence numbers using expression transformation?
How can repository reports be accessed without sql or other transformations?
What are the settings that you use to configure the joiner transformation?
What is workflow manager?
How to create the source and target database connections in server manager?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the benefit of session partitioning?
What does update strategy mean, and what are the different option of it?
What is data movement mode in Informatica and difference between them?