IN Informatica, I have 10 records in my source system. I need
to load 2 records to target for each run. how to
perform.please let me know. I know by using Mapping variable
we can perform but how to load please any one explain.
- 3 Answers
- 12355 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankit kansal
Overall Desc
SRC-->>SQ-->>EXPR-->>FILTER-->>TARG
create a mapping variable name $$max_bound of integer data type and aggregation type max
now in expression variable
seq v seq+1
o_seq o seq
v_temp v v_temp+1
curr_val v IIF(v_temp=1,setmaxvariable($$max_bound,$$max_bound+2),0)
o_map_val o setvariable($$max_bound,NULL)
now come to filter transformation
and write condition as
(seq<=$$max_bound)AND(seq>$$max_bound-2)
Thanks
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen
You are right , this can be achieved only with the help of
the mapping variable. and also a filter transformation
1) create a mapping variable and assign a default value 0
2)during the first run , i hope ur source must have an seq
num in it, if not use the seq gen and have unique sorted
record.
3)in a n expression , just have v_max_filter =
@@map_variable + 2 and v_min_filter = @@map_variable - 2
4) in the filter transformation , put the filter on the
seq_column <= v_filter and seq_column >= v_min_filter
5) enjoy a coffe, this will run
| Is This Answer Correct ? | 4 Yes | 6 No |
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Explain and compare etl & manual development?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
how do u decide whether u need to do aggregations at database level or at Informatica level?
what is session partitioning?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are your responsibilities as an etl tester?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What is a materialized view log?
How to fine tune mappings?
Explain different types of partitioning?
Teradata 
