How to use procedural logic inside infromatica?



How to use procedural logic inside infromatica?..

Answer / Avdhesh P.singh

Informatica supports procedural logic through the use of Script Transformations. This allows you to write custom code (using languages such as JavaScript, Python, and VBScript) to perform complex data manipulations that are not available with standard transformations. To use external procedural logic, Informatica provides APIs like PowerShell script tasks or CLI (Command Line Interface) which can be integrated into your workflows.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is the predefined port in dynamic lookup

2 Answers  


Why should we use star schema in datawarehouse design?

2 Answers   Wipro,


Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


what is scd?

6 Answers  


Two Default User groups created in the repository are ____ and ______

2 Answers  


how to work with mapplet designer in informatica?

7 Answers  


When you move from devel to prod how will you retain a variable

1 Answers  


Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  


Differentiate between source qualifier and filter transformation?

1 Answers  


Explain lookup transformation is active in informatica

1 Answers   Informatica,


Hi experts, can anyone tell how much we use plsql in real time

3 Answers  


What is confirmed dimension and fact?

7 Answers  


Categories