Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shobhan
if input number of rows are not equal to output number of rows, that would be Active transformation. In Union Transformation, input will more and output will be less. SO, this is a Active Transformation.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to generate sequence numbers without using the sequence generator transformation?
what is SDLC way of code development?
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
Explain pmcmd command usage in informatica
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 .
server hot-ws270 is connect to Repository B. What does it mean?
what is the -ve test case in your project.
What is an Integration service in Informatica?
How to start a workflow using pmcmd command?
How can we improve session performance in aggregator transformation?
Is stop and abort are same in informatica?
Enlist the differences between database and data warehouse.
Write the unconnected lookup syntax?
Plz can any one say me how to get the informatica certification materials and dumps
