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
- 12101 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 Active lock explain
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is different between the data warehouse and data mart?
What is Index Caches size?
How you can differentiate between connected lookup and unconnected lookup?
Differences between connected and unconnected lookup?
Slowly changing dimensions, types and where will you use them
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How can you validate all mappings in the repository simultaneously?
Explain the different dimensions.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is an unconnected transformation?
How to join three sources using joiner? Explain though mapping flow.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
