my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
- 10 Answers
- 16142 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 is an active transformation?
How an expression transformation differs from aggregator transformation?
How do you convert single row from source into three rows into target?
Different sorts of metadata that stores in the storage facility?
What are active and passive transformations?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Where are the source flat files kept before running the session?
how tokens will generate?
How can informatica be used for an organization?
What is the fact table?
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 mapping variables in informatica? Where do we use them?
What is the need for an etl tool?
tell me about your project functionality
How many transformations can be used in mapplets.
