I have a source either file or db table
Eno ename sal dept
101 sri 100 1
102 seeta 200 2
103 lax 300 3
104 ravam 76 1
105 soorp 120 2
Want to run a session 3 times.
First time: it should populate dept 1
Second time: dept 2 only
Third time: dept 3 only
How can we do this?
Answers were Sorted based on User's Feedback
Answer / srinivas
create a mapping variable
example;
name type datatype pre scal agg
$variablename variable decimal 3 0 max
filter transformation
filter condition: setvariable($variablename,($variablename+1))
+1 is used as the consecutive deptno diff is 1
Is This Answer Correct ? | 11 Yes | 0 No |
What is joiner transformation in informatica?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
How to use Normalizer transformation?
What is a rank transform?
What is the use of code page?
what is the monster dimension plz give me one example
What are Dimensions and various types of Dimensions?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
What are variable ports and list two situations when they can be used?
Can a joiner be used in a mapplet.
why we r using presql&postsql in source qualifier?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?