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
- 10042 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
what is unit testing?tell me proceedure
Explain pmcmd command usage in informatica
What is enterprise data warehousing?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What does refresh system mean, and what are its distinctive choice?
Enlist the advantages of informatica.
How to generate sequence numbers without using the sequence generator transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Differentiate between source qualifier and filter transformation?
Can we override a native sql query within informatica?
What is meant by a domain?
What is joiner transformation?
Please let me know how to make encryption and decryption with example?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
