Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Which kind of index is preferred in DWH?
what is the necessity to use update strategy?(except for updates)
what is the purpose of surrogate key and diff between primary key&surrogate key
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
Define sessions in informatica etl?
Can a joiner be used in a mapplet.
Explain in detail scd type 2 through mapping.
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
What is blocking transformation?
what is pre and post sql and what is diff between source presql and target pre sql
What are the new features in Informatica 5.0?