What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?


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

Post New Answer

More Informatica Interview Questions

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,


What is a dimensional model?

0 Answers  


How do you change a non-reusable transformation to reusable transformation?

0 Answers  


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,






in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,


we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,


How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,


How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  


What are the methods for creating reusable transforamtions?

2 Answers  


my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,


in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,


Categories