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 / balaramesh

using constraint based transformation

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the Default Source Option For Update Strategy Transformation?

734


What is standalone command task?

681


What are the types of schemas we have in data warehouse and what are the difference between them?

503


Explain target update override in informatica

610


What is difference between a gateway node and worker node?

598






Explain what transformation and how many are there in informatica?

467


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1443


What is a code page?

688


How is union transformation utilized?

546


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?

1479


Explain how many types of dimensions are available in informatica?

562


What are the different options available for update strategy?

550


How to load data in informatica ?

548


What is a filter transformation and why it is an active one?

542


Explain 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?

524