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
- 12933 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are various etl tools in the market?
what is an ETL or ETT? And what are the different types?
Explain about round-robi?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
what is pmrep command?
What are the steps involved in etl process?
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.?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Explain the key challenges that you face while performing etl testing.
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What are the etl testing operations includes?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is etl process? How many steps etl contains?
