Interested to Buy Any Domain ? << Click Here >> for more details...
how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 18701 Views
- I also Faced
- E-Mail Answers
Answer Posted / sathish
put primary key to target it will reject duplicate rows
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is the use of target designer?
Can you generate sequence numbers without using the sequence generator transformation?
without table how to come first record only in oracle?
What is a joiner transformation?
What is the status code in stored procedure transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
How do you load alternate records into different tables through mapping flow?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain pushdown optimization and types in informatica
What is a filter transformation?
What is a stored procedure transformation?
What are the different options available for update strategy?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can we use mapping variables in informatica? Where do we use them?
What are multi-group transformations?
