Interested to Buy Any Domain ? << Click Here >> for more details...
if i am having 10 records in source, i want 20 records in
target...how will you do it
- 13 Answers
- 18076 Views
- BirlaSoft, IBM, I also Faced
- E-Mail Answers
Answer Posted / sateesh a
run the session twice.
before running the session disable the target truncate load
option and disable the distinct option in target.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is native users?
What are the prerequisite tasks to achieve the session partition?
What is data transformation manager process?
How many ways are there to do 'remove duplicate records in informatica'?
What is primary and backup node?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is enterprise data warehousing?
What is the function of aggregator transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in 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
What is workflow monitor?
Please let me know how to make Data masking in informatica..
