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
- 11908 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 unit testing?tell me proceedure
In informatica workflow manager, how many repositories can be created?
Differentiate between a repository server and a powerhouse?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Briefly explain the aggregator transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How big was your fact table
Explain the different kinds of facts.
What are the different clients of powercenter?
How can we remove the duplicates from flat file source?
What is the use of code page?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is depict expression change?
When do you use sql override in a lookup transformation?
