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
How we can create indexes after completing the load process?
Plz can any one say me how to get the informatica certification materials and dumps
Whats there in global repository
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.
What is the difference between Active and Passive transformation?
What is intricate mapping?
How to generate sequence numbers without using the sequence generator transformation?
What is informatica? Why do we need it?
How can we handle two sessions in informatica?
Briefly define a session task?
How union transformation is used?
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
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
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
without table how to come first record only in oracle?