can we override a native sql query within informatica? Where do we do it? How do we do it?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

how will you get 21 to 30 record from 50 records?

6 Answers  


for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,


What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,


What are conformed dimensions?

1 Answers  


what is upstream and downstream transformation?

7 Answers  






How many repositories can be created in informatica?

1 Answers  


How many transformations can be used in mapplets.

0 Answers  


what is the difference between mapplet & stored procedure?

1 Answers  


What is A complex mapping?

3 Answers   TCS,


As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  


Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  


Categories