Question { TCS, 2981 }

Hi experts,
> I 'm having data like this and it's in flat file.
> sno,name,marks,result
> 1, ak, 80,p
> 2, , ,20,f
> 3,jack,55,p
>
> now in the second row a comma(,) is placed instead of
name(char).
>
> when importing into SQ , in flat file wizard the num of
columns increased to 5 instead of 4.
>
> could you tell me how to over come this issue.........

Answer

EDIT MANUALLY IN FLATFILE.
REPLACE IT AS SOMEOTHER CHARACTER.
AND PASS IN MAPPING. iN MAPPING YOU CAN REPLACE.

Question { TCS, 6932 }

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

map1
map1
1.source
2.sorter
3.filter ( gender = male)
4.connect to male_name column in target

map2
1.source
2.sorter
3.filter( gender = female)
4.connect to female_namw column in same target)

target load plan 1,2
start the load.