Question { TCS, 10353 }

following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target

male female
ram ramya
david deesha
kumar

any body give solution above question?

Answer

use router transformation, In that 2 groups
1 is male, 2 is female,
target is single, but we drag the table twice

In that router 1st group condition
select * from table where gender='male'
2nd group condition
select * from table where gender='female'

Question { UST, 17998 }

Why we select the table which has minimum number of records
as Master table in joiner?

Answer

faster perfomance of loading

Question { Polaris, 8430 }

following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?

Answer

use router transformation
in that give condition 1st row id to 1st target
and so..

Question { iNautix, 10232 }

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4
session after 5th session how will you do?

Answer

first s1, s2, s3, s4 are run at parallel mode, and these 4
sessions are conncet to s5
or
Use Decission Task

Question { 6039 }

What is constraint based loading exatly? And how to do this?
I think it is when we have primary key-foreign key relation
ship. Is it correct?
please answer me.
Advance Thanks.

Answer

Constraint Based Load order defines load the data into
multiple targets depend on the primay key foriegn key reltion.

set the option is: Double click the session
Configue Object check the Constraint Based Loading