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
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
During the running session, output files are created by informatica server. Enlist few of them.
Explain lookup transformation source types in informatica
What is the way to execute pl/sql script using informatica mapping?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain incremental aggregation in informatica
What is informatica metadata and where is it stored?
What is the difference between informatica 7.0 and 8.0?
What do you mean by channel change?
What do you mean by enterprise data warehousing?
Enlist few areas or real-time situations where informatica is required.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the settings that you use to configure the joiner transformation?
Explain joiner transformation in informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Briefly describe lookup transformation?