what is the use of Java Transformation in Informatica 8.x?
Answers were Sorted based on User's Feedback
Answer / vishnuvardhan
Active or Passive & Connected. It provides a simple native
programming interface to define transformation
functionality with the Java programming language. You can
use the Java transformation to quickly define simple or
moderately complex transformation functionality without
advanced knowledge of the Java programming language or an
external Java development environment
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / ankita
Java transformation can be used to perform complex logic transformation for input data.
Generating intermediate records: For example ,a Java transformation contains two input ports that represent a start date and an end date. You can generate an output row for each date between the start date and end date. Using Loop : For example, you can define transformation logic to loop through input rows and generate multiple output rows based on a specific condition. -
See more at: http://www.tutorial.tecktricks.com/java-transformation-in-informatica-with-example/
| Is This Answer Correct ? | 0 Yes | 1 No |
What does “tail –f” command do and what is its use as an Informatica admin.
I have a flat file, want to reverse the contents of the flat file
What is a command that used to run a batch?
What are partitions in informatica and which one is used for better performance?
how many ways can we implement SCD2?
How can you display only hidden files in UNIX
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions 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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How can we use batches?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
The question was on time stamp. what is the difference between HH and HH24 when to use when.