State the differences between shortcut and reusable transformation



State the differences between shortcut and reusable transformation..

Answer / Km Divya Budiyal

Shortcut transformations are used for creating temporary connections between two data sources, while reusable transformations allow users to create a single transformation that can be used multiple times in various data flow tasks. Shortcuts don't persist across data flow executions, whereas reusable transformations do. Furthermore, shortcut transformations cannot be parameterized or shared with other users, whereas reusable transformations can.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

what is the difference between OLTP database and data warehousing database?

4 Answers  


Define slowly changing dimensions (SCD)?

1 Answers  


CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"

11 Answers  


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

1 Answers  


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

1 Answers  


List few etl bugs?

1 Answers  


what is an ETL or ETT? And what are the different types?

1 Answers  


What are cubes and olap cubes?

1 Answers  


1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,


Can u access a repository created in previous version of Informatica?

1 Answers   DELL,


what are Lookup caches options? Including persistent caches.

1 Answers  


you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  


Categories