Hi All, Mapping: ======== Src==>SQ==>Exp(id,name,sal,up_sal,V

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000
4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement
is like this id name sal up_sal,1 aa 1000 null,2 bb 2000
1000, 3 cc 3000 2000
4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on

so how can i get it plez reply for this as soon as possible
, thanks in advanced

Question Posted / babu

9 Answers
11554 Views
I also Faced
E-Mail Answers

Answer Posted / babu

Hi All,

Mapping:
========

Src==>SQ==>Exp(id,name,sal,up_sal,V_PreviousSal(variable
port))==>Trg

Exp Transformation is have 5 ports,
1.id port (i/o)
2.name (i/o)
3.sal (i/o)
4.up_sal is the ouput port =V_Previoussal
5.V_PreviousSal port is the output port,the value of this
port is sal
Expression of this(V_PreviousSal) port =sal

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are session parameters ? How do you set them?

1828

What is the commit type if you have a transaction control transformation in the mapping?

1019

What is flashback table ? Advance thanks

1922

permutations of mapplet

2489

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1887

How to load last n records of file into target table - informatica

1053

What is fact table? Explain the different kinds of facts.

1063

What are the different types of transformation available in informatica.

1084

Can you generate sequence numbers without using the sequence generator transformation?

1102

Design a mapping to load a target table with the following values from the above source?

1327

Enlist the advantages of informatica.

1046

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1263

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1838

What is the meaning of up gradation of repository?

1959

explain about unit testing? in real time?

2181