my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
Answer Posted / soujanya
create an instance of target
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
Briefly describe lookup transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is event and what are the tasks related to it?
What are the transformations that are not supported in mapplet?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are different types of transformations available in informatica?
which one is better performance wise joiner or look up
Repository user profiles
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 domain in terms of informatica?
Informatica settings are available in which file?
How can we delete duplicate rows from flat files?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance