select count(1) from emp? what is the o/p?

TCS,

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

CompuSoft, EDS, TCS,

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

TCS,

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

TCS,

Can we insert ,update ,delete in target tables with one update strategy tran.?

Zensar,

why we use materialized view over view?

Zensar,

can session assigned multiple mappings or not?

Zensar,

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

Emphasis,

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

Emphasis,

what is curr val use for in sequence generator?

Emphasis,

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

Emphasis,

what is the necessity to use update strategy?(except for updates)

Emphasis,

What is the method of seperating unique and duplicate records in session level?

Emphasis, JBL, Wipro,