Can we override a native sql query within informatica?


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

Post New Answer

More Informatica Interview Questions

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,


I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,


what is mean by grouping of condition column in lookup transformation?

1 Answers  


Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,






What is dynamic cache?

0 Answers  


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  


Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,


If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,


in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,


How can you complete unrcoverable sessions?

1 Answers  


HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,


Categories