Interested to Buy Any Domain ? << Click Here >> for more details...
my source like dis
10,asd,2000
10,asd,2000
10,asd,2000
20,dsf,3000
20,dsf,3000
20,dsf,3000
like dis and my requirement is first record is inserted into
first target and duplicates of first record is inserted into
second target ...like dis way ...?
how to achieve dis?
- 4 Answers
- 9054 Views
- Mind Tree, Polaris, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
1.first sort the data with sorter t/r as ID key column and
create below port in exp transformation
var2= var1
id
var1=id
rec_count=iff(var1=var2,rec_count+1,1)
2.Give all the port to router t/r and give the filer
condition as below
rec_count=1 then to first target
default to 2nd target
Let me know if any things is wrong.
Thanks & Regards
Santosh Kumar Sarangi
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How would you copy the content of one repository to another repository?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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
What are the settings that you use to configure the joiner transformation?
What does role playing dimension mean?
Write the different tools in the workflow manager?
What are the different types of transformation available in informatica.
What do think which one is the better joiner or look up?
What are the differences between oltp and olap?
How identifying bottlenecks in various components of informatica and resolving them?
In informatics server which files are created during the session rums?
How can a transformation be made reusable?
What is the meaning of up gradation of repository?
What is native users?
What are the different types of olap? Give an example?
