how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 16834 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajit kumar pradhan
if it is a relational source then click on source Qualifier
properties then check Distinct option.
if it is a flat file then it can't work .......
click on target defination select target menu and click
generate/execute then it come out one dialog box come out
then check primary key check box..it avoid duplicale row...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the new features of informatica 9.x in developer level?
Please let me know how to make Data masking in informatica..
How to generate sequence numbers?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
scenario where i can use only concurrent execution of workflow.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the difference between a connected look up and unconnected lookup?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
How can we use batches?
How you can differentiate between connected lookup and unconnected lookup?
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 do we call shell scripts from informatica?
How many numbers of sessions can one group in batches?
What are the popular informatica products?
