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
- 10041 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / rocky!!
Here is another answer.
--> SEQ1
SD --> SQ --> EXP --> EXP --> TGT
--> SEQ2
1) Add SEQ1. Keep Starting value as 1 with cycle attribute set in after end value 100.
2) Add Another SEQ2. This is to keep a tab on the record count on the incoming data flow.
3) Get NEXTVAL & NEXTVAL1 from SEQ1 and SEQ2 and dump it in EXP.
4) in EXP, add Varibale port "V_OUTPUT_DECISION" and write code "CEIL(NEXTVAL1/100)"
5) in EXP, add variable "V_BATCH_NO" and initialise value as 10.
6) in EXP, add output port "OUTPUT_DECISION_BATCH_NO" and write code as "V_OUTPUT_DECISION*V_BATCH_NO"
7) connect fields viz, YEAR, DESC, MONTH, SALARY and BATCHNO to Target.
I guess this is the generic code. Bring any number records, should work.
Cheers!!
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain pmcmd command usage in informatica
What is the difference between stop and abort in informatica
Briefly describe lookup transformation?
What are the measure objects?
What is the scenario which compels informatica server to reject files?
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?
how tokens will generate?
write a query to retrieve the latest records from the table sorted by version(scd)
What is a dimensional model?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is a repository? And how to add it in an informatica client?
What's the layout of parameter file (what does a parameter file contain?)?
What does refresh system mean, and what are its distinctive choice?
What is a surrogate key?
what is the size of u r source(like file or table)?
