Hi, Using Informatica SRC-SQ-SRT(key used id)-EXP( v_name = IIF(ID=v

SOURCE
1 a
1 b
1 c
2 a
2 b
2 c

TARGET
1 A B C
2 A B C

In oracle & informatica level how to achieve

Question Posted / ankit kansal

4 Answers
7827 Views
iGate, I also Faced
E-Mail Answers

Answer Posted / ankit kansal

Hi,
Using Informatica
SRC-SQ-SRT(key used id)-EXP(
v_name = IIF(ID=v_prev_id,v_prev_name ||' '||UPPER(name),UPPER(name))
v_prev_name = v_name
out_name = v_prev_name
v_prev_id = ID
)-AGG(group by id will give u last row)-TGT

Using Oracle

select value from (
select id ||' '||upper(name) ||' '|| lead(upper(name),1) over (partition by id order by id) ||' '|| lead(upper(name),2) over (partition by id order by id) value from ankit_temp order by 1
)temp where length(value)>0 order by value;

http://deepinopensource.blogspot.com/

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2296

What is the use of code page?

1026

What is informatica? Why do we need it?

1058

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9759

What are Dimensional table?

1014

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2409

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1820

Separate from an archive server and a powerhouse?

918

Enlist the advantages of informatica.

1018

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1956

What is a mapplet/worklet in informatica?

1138

What are active and passive transformations?

1037

What are the prerequisite tasks to achieve the session partition?

1202

Describe the impact of several join conditions and join order in a joiner transformation?

1023

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

997