there is a product table
prodid prodname price
100 cinthol 10
101 hamam 10
102 neem 20
103 cake 30
in the above table the price of some products are
duplicated and some product prices are distinct we want to
push the duplicated prices to one target and non-duplicated
prices to other target without using expression and
sequence generator transformation
Answer Posted / akash
Hi Krish,
In this case we will get distinct records in one table and
one record each for duplicate records of each table.
For ex:
Source:
101 neem
101 neem
101 neem
Duplicate target:
101 neem
Can you suggest any way through which we can get as many
duplicate records as there are in the source?
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to start a workflow using pmcmd command?
Explain what are the different versions of informatica?
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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Define Pmrep command?
What are the types of caches in lookup? Explain them.
How can you generate reports in informatica?
What is target designer and target load order?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the difference between informatics 7x and 8x and what is latest version?
What are the guidelines to be followed while using union transformation?
How to extract sap data using informatica?
How to join three sources using joiner? Explain though mapping flow.