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

How we can create indexes after completing the load process?

619


Plz can any one say me how to get the informatica certification materials and dumps

1602


Whats there in global repository

1272


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1771


What is the difference between Active and Passive transformation?

640






What is intricate mapping?

594


How to generate sequence numbers without using the sequence generator transformation?

651


What is informatica? Why do we need it?

643


How can we handle two sessions in informatica?

621


Briefly define a session task?

595


How union transformation is used?

595


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1741


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1540


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2078


without table how to come first record only in oracle?

1861