Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 11351 Views
- I also Faced
- E-Mail Answers
Answer Posted / moorthy, g
Hi
In the variable port you have add
pre_sal = v_SAL
v_sal=SAL
SAL = SAL
o_update_sal = pre_SAL
Best Regards,
Moorthy. G
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load only null records into target? Explain through mapping flow.
Which development components of informatica have the highest usage?
How to generate sequence numbers without using the sequence generator transformation?
What are ETL Tools?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explian the Process of deployment groups in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What happens when a session fails and you click on recover?
What is the difference between stop and abort in informatica
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What does “tail –f” command do and what is its use as an Informatica admin.
where to store informatica rejected data?
