Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
- 4 Answers
- 10822 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / laksh
You can do this in one mapping by using sorter and then
expression transofrmation ..in Expression use 3 variables ..
1 Current 2 previous 3 route..
if prevous = current sent to table 2 else 1.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
How do you use reject loader.
Explain the different dimensions.
How does a rank transform differ from aggregator transform functions max and min?
Explain how many types of dimensions are available 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
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?
explain one complex mapping with logic? sales project?
What is the difference between informatics 7x and 8x and what is latest version?
What is dimensional table?
How do you change a non-reusable transformation to reusable transformation?
What is decode in static cache?
How to extract the informatica rejected data?
How can a transformation be made reusable?
What are the modules in Power Center
