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

There are 3 groups in router transformation in which there
are no conditions mentioned, so what happens if I connect
these groups to the 3 targets? How many records gets into
each target.(suppose if we are getting 10 records from the
source)

Question Posted / dantu.manohar

Answers were Sorted based on User's Feedback



There are 3 groups in router transformation in which there are no conditions mentioned, so what ha..

Answer / chakri

10 records into 1 target
10 records into 2 target
10 records into 3 target

Is This Answer Correct ?    32 Yes 0 No

There are 3 groups in router transformation in which there are no conditions mentioned, so what ha..

Answer / eswar

All the 3 targets get 10 recrods each

Is This Answer Correct ?    8 Yes 0 No

There are 3 groups in router transformation in which there are no conditions mentioned, so what ha..

Answer / venky

3 group conditions are defaultly true
so,each target get 10 recards
totally 30 records

Is This Answer Correct ?    4 Yes 0 No

There are 3 groups in router transformation in which there are no conditions mentioned, so what ha..

Answer / raju

Without condtion by default all rows are load to given target/targets.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

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  

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,




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

2 Answers   Polaris,

whatis the default data driven operation in informatica

2 Answers  

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

Mapplets can you use an active transformation in a mapplet,

1 Answers  

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories