How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 8384 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / moorthy g [ibm]
1. Target Update Override
2. Select Unique Value (means)
Exp:
out_flag: decode( true, pre_no=no, 'Y', 'N')
pre_no = no
Router:
Out_flag: Y --- Unique Value
Default --- Duplicate Value
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to extract the informatica rejected data?
Where can we find the throughput option in informatica?
How do you load only null records into target? Explain through mapping flow.
What is depict expression change?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
without table how to come first record only in oracle?
How you can differentiate between connected lookup and unconnected lookup?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is lookup transformation?
Mention few advantages of router transformation over filter transformation.
Plz can any one say me how to get the informatica certification materials and dumps
How do you load unique records into one target table and duplicate records into a different target table?
Can we create multiple integration service on single repository?
Explain the features of connected and unconnected lookup.
