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
- 11807 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
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
how to load dimension table and fact table. plz tell me the steps.
How to generate sequence numbers using expression transformation?
Global and Local shortcuts. Advantages.
can u give example for factless fact table
What are pre and post-session shell commands?
What are the components of the workflow manager?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What do you mean by enterprise data warehousing?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is fact table? Explain the different kinds of facts.
What are junk dimensions?
In which transformation you cannot drag ports into it?
What is the meaning of up gradation of repository?
What is the maplet?
