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
- 10916 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / srini
SQ>>EXP>>>TAR
Generate seq in exp and check for condition like
iif(seq<100,10,iif(seq>100 and seq<=200,20,iif(seq>200 and seq<=300,30,40)))
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
where to store informatica rejected data?
Define mapplet?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Why filter transformation is an active one?
What is lookup transformation?
What is update strategy transform?
How do you use reject loader.
Explain the difference between a data warehouse and a data mart?
What is joiner transformation?
Explian the Process of deployment groups in informatica
Explain scd type 3 through mapping.
How do we call shell scripts from informatica?
What are data-driven sessions?
What is a grid in Informatica?
What is a repository manager?
