How can we use external procedural logic in informatica?
- 1 Answers
- 989 Views
- I also Faced
- E-Mail Answers
Answer / Deepanshu Sharma
Informatica allows you to use external procedural logic by incorporating custom scripts, functions, and procedures written in languages like SQL, Java, C++, or Python. You can create custom transformations using the Script Transformation component, which enables you to write code directly within Informatica. Alternatively, you can call external scripts or stored procedures using the External Procedure transformation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what is the meant by Normalization and de-normalization?
how many maximum session supports to multiload in teradata ??
what is different between sequential batch and concurrent batch and which is recommended and why?
Explain etl mapping sheets?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
how would u estimate the size of Lookup transform data and index cache?
What are your responsibilities as an etl tester?
What are the ETL Testing Operations?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
what is the advantage of persistent cache? when it should be used?
Teradata 
