Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11627 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / nitin
Source->SQ->Sequence->Exp->Target
In Sequence Generator:
Give Start Value = 1
End value = 100
Check the Properties as CYCLE.
Give the following condition In Expression Transformation:\
O_SEQUENCE= NEXT_VAL
COUNT = IIF(O_SEQUENCE > 1 AND O_SEQUENCE <= 100, COUNT+10)
Make the default value of COUNT as 0
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Define update strategy?
how many types of dimensions are available in informatica?
Difference between Target-based loading and constraint-based loading?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Differentiate between source qualifier and filter transformation?
Clarify the utilization of aggregator cache record?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How you prepared reports for OLAP?
Differences between version 7.x and 8.x.
On which transformations you created partitions in your project?
How can we handle two sessions in informatica?
Explian the Process of deployment groups in informatica
What is the scenario which compels informatica server to reject files?
