after source qualifier, Use an expression transformer , in that take an v

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?

Question Posted / jaspreet banga

8 Answers
12615 Views
BRAD, TCS, I also Faced
E-Mail Answers

Answer Posted / jaspreet banga

after source qualifier, Use an expression transformer , in
that take an variable port name 'FLAG', and in that use the
decode function as 'FLAG = DECODE(GENDER=MALE,'M','F')'.
after that place an router transformer and for each flag
condition use seperate instance of target and hence you
will get what you want.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what are the different versions of informatica?

1099

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1963

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1201

What are connected or unconnected transformations?

1123

In how many ways we can create ports?

1123

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

What is standalone command task?

1318

How can you differentiate between powercenter and power map?

1091

What does cheating measurement mean?

1063

What's the layout of parameter file (what does a parameter file contain?)?

2385

Explain sessions and how many types of sessions are there?

1011

What is parallel processing in informatica?

1714

What is the surrogate key?

1263

What does command task mean?

1155