my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
- 10 Answers
- 16775 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answer Posted / jay
Very Simple method
QRC-----> TRGT
|
----> TRGT
Have two instance of target and
connect source to both target instances.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the main issues while working with flat files as source and as targets ?
Enlist the differences between database and data warehouse.
what is index?how it can work in informatica
What is a snowflake schema?
What are the types of caches in lookup?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How to elaborate powercenter integration service?
How you can differentiate between connected lookup and unconnected lookup?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Define pmcmd command?
wf dont have integration severances how you can run?
What do mean by local and global repository?
State the limitations where we cannot use joiner in the mapping pipeline?
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
