Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13592 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
Is hadoop a etl tool?
Difference between flat files and relational sources?
Explain about round-robi?
What is staging area referring to?
what make u disappointmnets in u r career
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 ?
Do we need an ETL tool? When do we go for the tools in the market?
What is etl process?
Is apache nifi an etl tool?
what is the use of structures?how many nodes can u create in a structure?
Explain the use lookup tables and Aggregate tables?
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.?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are the names of the layers in etl?
what are the session parameters? How do u set them?
