i have 1000 records in my dource table, the same i have in
target ,but a new column added in target as "batchno", and
this column adds no 10 for 1st 100 records and 20 for next
100 records and 30 next 100 records and vice versa. how to
acheive this?
- 6 Answers
- 10047 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / rajkumar
it's just like a simple pass.But we have to use an
expresion in between source and target we have to continue
the loop of variable port has to continue for every 100
records.
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
tell me the rules and responsblites in our project(my project is development)
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Define Pmrep command?
Explain lookup transformation in informatica
Briefly describe lookup transformation?
Plz can any one say me how to get the informatica certification materials and dumps
what is Active lock explain
Explain what are the different types of transformation available in informatica.
How do you update the records with or without using update strategy?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Clarify the utilization of aggregator cache record?
Explain about cumulative Sum or moving sum?
What are the transformations that are not supported in mapplet?
how many types of dimensions are available in informatica?
What is a joiner transformation?
