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
- 11823 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
What is a connected transformation?
What does cheating measurement mean?
How can one identify whether mapping is correct or not without connecting session?
what is the Default Source Option For Update Strategy Transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is rank index in rank transformation?
what are the Methods For Creating Reusable Transformations?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
During the running session, output files are created by informatica server. Enlist few of them.
What is a transaction control transformation?
What are the new features of informatica 9.x developer?
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 do you manage the Parameter files while migrating your data from one environment to another environment?
Which transformation is needed while using the Cobol sources as source definitions?
Explain sessions and how many types of sessions are there?
