How to generate or load values in to the target table based on a column value using informatica etl tool.


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

Post New Answer

More Informatica Interview Questions

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,


IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,


What is the Router transformation?

2 Answers   Informatica,


write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,


Differentiate between joiner and lookup transformation?

0 Answers  


lookup transformation with screenshots

0 Answers   TCS,


we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,


In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  


yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,


who to split dimentions into sub dimention

3 Answers   Wipro,


how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,


Categories