1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Transformer is a __________ stage
option1:Passive
2.Active
3.Dynamic
4.Static

Question Posted / mangesh

Answers were Sorted based on User's Feedback



Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static..

Answer / pavan

active

Is This Answer Correct ?    15 Yes 1 No

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static..

Answer / vikas

Dynamic more then active stage because its not taking space
in your DB its initiate run time with session, cashe data
do tranformations and end with session.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

Does an informatica transformation support only aggregate expressions?

1 Answers  

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

What are the tasks that source qualifier perform?

1 Answers   Informatica,

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

Why do we need informatica?

1 Answers  

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

in which situations do u go for snowflake schema ?

2 Answers   TCS,

What is resilience time?

1 Answers  

What is a grid in Informatica?

1 Answers  

For more Informatica Interview Questions Click Here
Categories